I had a 2007 Z06 for 3 1/2 years. I put something like 30,000 miles on it (Bought it with 15k) in that time period so I certainly drove it. Then again where I live it's possible to drive it year round. I daily drove it on and off, the Jeep we have spent a lot of time with a blown motor (twice!!!). Regardless of which Corvette you choose you'll have the same daily driver experience give or take.
The Corvette sucks in the rain. Simple as that. I had tires that were NOT below the wear bars but they were a little tired. Scariest drive of my life going about 15 miles in a rainstorm. Hydroplaning everywhere. New tires helped that somewhat but the rear tires are so wide (between 325 and 345 depending on what tire you choose) that they hydroplane super easily.
Road noise was definitely something I kept in mind. Again this is dependent on what kind of tires you have, the run-flats that come on the car stock are SO NOISEY. The NT05's I replaced them with were not nearly as noisey. I hear the new Pilot Sport Cups are good though. And they're fantastic tires. You know a set of rear tires along is going to set you back over $1,000 right?
Parking lots. Oh the joys of driving a Corvette in a parking lot. Just getting in and out of a parking lot can be a challenge because of how low the car is. You will get into good habits or you will destroy the front of your car from scraping. And then there are speed bumps. There are some you can conquer slowly with no issues. There are others no matter what you do the exhaust WILL scrape and all you can do is cringe. Also remember you're now committed to parking in the middle of nowhere.
Gas millage. Here is where the Corvette (IMO!!) really does well. I was averaging between city and highway around 20mpg. On the highway though I was averaging 26-28! With the super huge gears it helps a lot. At 70mph you're not even at 2,000rpm (this is Z06 specific)
The Corvette tax is real. Very real. The same exact part for a Camaro or GTO will cost 30-100% more for the Corvette. The upside is that parts are super easy to find and there are lots of reputable places that can work on Corvettes.
I know I listed a lot of negatives, but I think you already know the positives. It's a Corvette. It's a race car. Obviously I did love my Corvette because I had it for so long. I replaced mine with a CTS-V back in January, and the V is an awesome, awesome vehicle. But gets 15-16mpg on my 40 mile round-trip commute. Feel free to shoot me a PM or whatever if you have any specific questions.
A photo of the two together for the first and only time