maybe i don't understand the full story behind your motivation to get another car is...maybe you are more geared towards getting something a bit more modern and peppier than the camry than something with better mileage.
if its just the mileage alone then i don't see how spending 10k on another car is financially sound...
figure your camry gets 20mpg. 15 gallon tank for ease of comparison
figure a commute of 50 miles a day, 5 days a week, 180 days a 'school year'...so thats 9000 miles at an average of 20mpg which means you went through 450 gallons of gas at 4$ a gallon figure 1800 dollars.
lets say you get another car that gets 40 mpg...
50miles a day, 180 school days at an average of 40mpg so thats 225 gallons of gas at 4$ a gallon thats 900 bucks with a savings of 900 dollars per school year.
lets say you are going to school for anesthesiology and will be commuting that mileage for 13 years...
with your camry, you'd spend 23,400 dollars on gas
with the new car, 11,700...
a savings of 11,700.
it took ya 10 years to make up for that initial investment of 10,000.
now there may be other options, such as vehicle age...a 2004 will "hopefully" last longer than your 92, althoguh from what i've seen...i do a lot less work on early 90s cars than i do 2000+ cars....could be the lack of obdii though lol
not trying to sway you, but its a pet peeve of mine when people say that they want to get a new car due to gas mileage alone...i know you said something peppier and fun
now for a recommendation: cruze! gangster lil cars, awesome warranty, somewhat peppy but very comfortable car. probably sucks in the winter but some BLIZZAKS would fix that ey?