I drive a 2004 Toyota Sienna. Yes, it is a minivan, and no, it is not the sexiest car around but it really is a great vehicle. I plan to drive it until it dies.
Pros: holds everything and everyone (I have 3 kids and a dog), handles great, never have a problem with it, lots of great safety features and bells and whistles. Seats can be re-configured in a bunch of different ways.
Cons: if one of the kids leaves a door open or an interior light on, the battery drains overnight. Drives me nuts!
DH drives a 1998 Honda Accord and loves it. It drives great, hasn't given him any trouble, and even got through a pretty bad wreck in 1999 with flying colors...he walked away unharmed, and the car still drives great after having been fixed. He plans to drive it forever and give it to the kids when they start driving. I can't think of any "cons" for his car. I highly recommend a used Accord.