If long-term reliability is a primary goal, I would suggest taking a look at the 2004-2008 Acura TSX and TL. If you want a manual transmission, the TSX will be your best bet. The TL with manual is very hard to find.
The TL is a great car with lots of power even with the auttomatic, though. But the TSX is a lot of fun to drive with the manual!
I'd be wary of buying an older vehicle with a navigation system. You'd be amazed how outdated a 2007 or 2008 nav system is today. And if the HVAC and audio controls are integrated into the nav screen and something breaks, the repair cost can be astronomical!