Much of what I'd say has already been said, but I'll chime in anyway.
I live in IL (north of Chicago, just south of the "Cheddar Curtain" - the IL/WI border). My Spyder is my DD between March/April and November/December for a 60-mile round trip to & from work. Has been since 2008 when I bought it.
If you're in a lot of stop-and-go traffic, the manual transmission can be your foe if you're not fond of shifting. I have an SMT Spyder and a 6-speed MT Spyder, and I love them both and I'm not bothered by shifting the 6speed. That said, my winter DD (a Tacoma) is also 6-speed MT, so it's not like I own an automatic vehicle, anyway.
I love that these cars make pretty practical DDs (unless you're carpooling with more than one person, of course) but then you can let loose on the weekends and have a blast with the SAME car that's your DD during the week. Not many people can say that. Plus, for me, the Spyder makes that drive a hell of a lot more enjoyable. Even in traffic.
I'd say drive one - or a few, for that matter - before you go further down the decision road. As you said, we're all enthusiasts. But this car is not for everyone. If you have any intentions of doing anything but watching the road and driving, this is NOT the car for you. It's very intolerant of sloppy or distracted driving.