Any of the 350 offerings probably drive well with an auto, including any LT1 F-body. Even a 2.73 car.
But I agree, even an L03 manual should be reasonably fun to drive, as long as it doesn't have sucky gears.
http://www.thirdgen.org/1992-chevy-camaro/
TGO says it has a 3.08.
It has either the standard 215/65SR15 or optional 235/55SR16. Both are about a 26" tire.
Gear ratios here:
http://www.thirdgen.org/calculations/
Not 100% sure but 2.95 1.94 1.34 1.00 .63, 1st through 5th.
So with a 3.08 and 26" tire, you are looking at about 40 mph in 1st at 5,000 rpm and at 70 mph in 5th gear, about 1,850 rpm. So just about the right blend of performance and fuel economy if you were an OEM.
It's also in that unfortunate zone of too short in 4th and too tall in 5th for optimized top speed. You'll be at 5,000 rpm in 4th at 120 and it would still have more and if you shifted to 5th, RPMs would drop to a little under 3,200. It may be able to maintain 120 but probably wouldn't accelerate. Then again, for all the times you are up there, 4th is a little shorter which gives better acceleration up to 120 so meh.