If you keep it stock and don't go to the track should be a fun car.
CLB the column lock bypass is a fix that should be considered.
I had two C5Z, one track prepared and the other stock, both were fun.
If I were to get a vette I would like a stock C6Z for big power.
An automatic C5 convertible for cheap would be a fun cruiser.
All the info you would ever need is on the Corvette forum.
https://www.corvetteforum.com/forums/c5-corvettes-1997-2004-2/