The '94 not be a smart buy. They're aren't especially reliable (certainly not Honda reliable), they get piss-poor gas mileage and most important for a family man they are death traps. Poor safety for front passengers and death sentences for rear passengers. In the '90s you had an excuse, but today I wouldn't put anyone I loved in something like that. And, no, you don't want to be seen in that. At best people will think you sold ambition on ebay, but more likely they'll think it's all your capable of. I don't think you wanna be that guy.
If you like the concept, look at a newer one. The 3rd gens had a lot of improvements including a second sliding door an AWD on some models - and they look reasonably modern instead of an '80s artifact.
WRT to the smell, try this stuff:
http://www.amazon.com/Chemical-Guys-...ical+guys+odor
It's amazing, no joke. Got what I think was cat pee smell out of the Santa Fe with ease, and subsequently mildew out of a coworker's Focus (she left the window down in the rain). Best stuff I have ever used.