It's funny, but you won't find a more dedicated car faction than manual transmission purists. The ranks unfortunately are dwindling in the U.S., what with rampant stop-and-go traffic and the difficulty using a cell phone, texting, and eating breakfast while trying to operate a traditional gear shift & clutch.
Just about every VW salesman we talked to did a double-take and was flummoxed when we said the Eos we were looking to buy for my wife had to have the 6-speed. The only salesman who didn't (and whom we eventually bought from) was a really nice Eastern European guy, who responded, "Good choice! My wife loves hers!" We did test drive a car with the DSG at one dealer, and although it's much better than an old-school automatic, to us it simply wasn't as much fun and the driving experience wasn't as involving.
We didn't trade in our old Sebring GTC Convertible, because, yes, it had a 5-speed. You think a dealer won't give you a fair trade-in value, try trading in a car with a manual tranny! Fortunately, I found a kindred soul via Craigslist and sold the Sebring in three days for $2K more than dealer offers. The buyer's kids were off to college, and she wanted an inexpensive, fun four-seater convertible with a standard.
The only problem with the Eos' transmission is that I don't drive it often, because it's my wife's DD. After driving my CRX or Dakota for a week, when we go out on a Friday night and I'm behind wheel of the Eos, I have to remind myself, "Okay, reverse is up and to the left..."