Seems to me like the OP is mindset on getting the old Beetle.
I'm sure there are those of us out here who have had the same mindset... only to have the cold, stinging hand of Reality change our minds several months down the road. For me, it was a TVR 280i that looked so cool, I just knew it would be different than the rest of them and not have the same problems and issues as all the rest, because mine was just gonna be different......
.......not........
Experience is a harsh, expensive teacher sometimes.
<snipped>
+1000. I have my own share of experiences for my credentials. IMO, get something inexpensive yet reliable that your wife likes (not you). Something that won't leave her stranded on the side of the road (like an '80 Stinkin' Lincoln - at least she could push the bug out of traffic).
I'm totally with you on the uniqueness vibe thing, but save that until you can afford it. Then, get what YOU want, but keep your wife happy too - that will earn you points for the long haul.
To me, good gas mileage is better than the '89 Suburban I had that got 8-10 mpg. It was a great gear hauler, got props on the road, but was hard to feed (and keep it full). The '01 Quest I have now isn't as large but gets 18-22 mpg and is reliable as can be. The AC will freeze you out of it, and it's got 18x,xxx miles on it and doesn't leak a drop of oil (try that in that beetle).
Others have recommended Toyota hatches/wagons; older Accords would fit the bill too, net you 27 mpg or better around town, and run forever.
Note to Josh: it only took you a couple of months down the road for reality to change your mind? You were a lot sharper than I was.
OP, in all seriousness, best wishes for you if you do get the VW, I hope it works good for you.