Regardless of what you end up buying go find a car that you can learn how to drive manual.
Go rent a car that is stick and pay the $14 per day insurance on it. You won't have to worry about blowing out your friends/parents clutch, lol.
If you're a guy... knowing how to drive stick is as important as knowing how to throw a baseball or build a campfire. If you're a chick... just think of driving stick as having ultimate control of your car. And lets face it, you ladies lovvvveeeeee ultimate control .