The "two personalities" thing in a car is something that I discovered early on and something that's mandatory, especially if it's going to be your only car. That's why things like the GTI, G35/37, 3-series, and so on, are so popular - they can do the fast stuff, but they are also a normal car when you need them to be, and they're also fun at normal speeds where it matters the most.
Here's the thing about the EVO. Yes it's insanely fast. But it's also a Mitsubishi Lancer, which is a TERRIBLE car. There's a reason why the EVO is so fast for so little money spent. Mitsubishi spent about $1 on refinement, and it was $1 wasted. If you think the MazdaSpeed3 is too civilized and too nice to live with day to day, buy an EVO. Stock up on headache medicine, you're gonna need it thanks to all the NVAH. Also, the "0-60 in 4.5" is a bit bullshit, only attained with brutal hard launching. If somebody with a blown 6 or V8 catches you off guard in the wrong gear, you're toast. Under about 3,000rpm or so the engine is basically dead. You can see the man behind the curtain when you look at 5-60mph "street start" tests, the "4.5 second" EVO becomes a 6.5 second+ car.
As for the 0-62 being a bit BS. That's BS. It has electronic launch control, not some random d-bag dropping the clutch. Plus it uses a DSG so what gear are you going to miss or get caught off guard by? I don't know where you are seeing a Evo X w/ DSG doing anything more than high 4's. 6.5 sec is ridiculous, my MR-S does that and that's even slower than my Legacy GT. It's impossible for an Evo to do 6.5 secs unless you start in reverse!___________
Q50 best looking? That's just a Mazda 6 clone.
Also, a lot of the cars you listed are hardly going to be affordable. My point was that it's not a good time to be an everyman enthusiast. Yes, there are a lot of exciting cars coming out over the 40k pricepoint but they're not for everybody.