I can't claim to be an expert, but the engineers at Chevy knew what they were doing most of the time.
The stock 9-leaf rear spring rate is around 200lbs/inch. The F41 heavy duty 7-leaf spring is about 300lbs/inch, as are the entry-level composite springs, which graduate up from that in steps to over 400lbs/inch. BTW, the stock rear spring probably SHOULD be about flat with a full tank of gas and a couple of passengers (ride height in the rear is adjustable via the outer rear spring bolts). What I'm trying to say is that the aftermarket stuff is aimed at handling and not at comfort, and Chevy chose 200lbs/in for a comfortable touring suspension, 300lbs/inch for performance.
GM has, I believe, Delco gas shocks recommended to replace midyear shocks, or you can go with an adjustable gas KYB or Bilstein or Koni, adjusted to the soft positions.
Replace all your suspension bushings and cushions with new stock rubber bushings (don't forget the A-arm and trailing arm bushings and the differential nose cushions as well as shock and sway bar cushions) for best comfort & least vibration. Tires are very important to riding comfort as well... I've heard Pirelli P4000 are excellent touring tires that I think can be had in hard-to-find Corvette sizes (205/75R15 or 215/70R15) at reasonable prices, as can the more expensive Michelin MXV4, and I've heard Coker Tire still offers a remake of the older Michelin X. High-speed balancing is a must, and have the alignment checked front & rear, altering front toe-in settings to accomodate the radials.
Vette Brakes & Products has a good selection of suspension parts
http://www.vettebrakes.com as does Van Steel
http://www.vansteel.com (get a catalog) and Long Island Corvette
http://www.licorvette.com and other vendors.