I NEED TO DRIVE A TURBO KAPPA..........
If possible, find one with a tune on it as well. Even just the GMPP tune makes a huge difference. 80 more lbs of torque makes it a different car. The 60 to 100 is just plain fun. This is running at 340 lbs of torque in a car that weighs just 2940 lbs; and peak torque hits at 3600 RPM. For comparison: That C5 you test drove (assuming it was at least 2001 model) pushes 360 lbs of torque in a car that weighs 3200 lbs. The pre-2001 C5 only put out 350 lbs of torque. And peak torque for the Vette doesn't hit till 4400 RPM. With the boosted and tuned Kappa, the fun power kicks in quicker.
For the record: I have driven about every fricken performance car ever built, including many Corvettes in all available body styles, except the new C7. The C5 is not a bad ride, but it is a dog. You really need to drive a C6. For the difference in cost, it is well worth it. Or find a C5 ZO6 (2001-2004 had an LS6 engine cranked up to 400 lbs of torque) For me, the Vette isn't fun until you hit 400 lbs of torque. And that is assuming I am driving down at sea level. Where I live, that 400 lbs turns into only about 320, so it still sucks.
But if you are going with the Vette, stick with something pushing at least 400 lbs of torque.
Personally: My favorite Vette was the C3. The thing was a rattle trap and quite honestly a POS. But man you could get it with about any big block GM made at the time. It was a lot of fricken fun and it had a kick ass look to it. I almost bought another one for my wife, back when she decided to go for the Sky Redline instead. It was a 1969 convertible with a 427 and a 4 speed. I never even drove it myself, because I knew I would want to buy it.
Tossed the keys to the wife and said go see what you think. She came back about 1/2 hour later with a big grin on her face. She said "this thing is just nasty fast, it is like your GS". I offered to buy it right there, but she hadn't had a chance to drive the turbo Sky yet; so she waited. A couple months later we finally got a turbo Sky in town. She drove it for 5 minutes, came back and said "I want it, but it has to be the color and options I want". Took my salesman another 4 months to get the one she wanted shipped into town.