Corvette has some good flow, but as others have pointed out the LT5 can be a real nightmare if it's not working. Generally speaking the game rules aren't that deep and I personally found it pretty easy to beat (and I consider myself an average player). There are a couple of fun modes and the theme is well integrated, especially if you know anything about the history of the actual Corvette automobile. The dragstrip is a neat toy but not all that engaging overall.
Depending on your skill level and other games you own, it could get boring fast. That said, I've had mine for 20 years and still enjoy it, but I also have a lot of other games to choose from.
As always, if you can try before you buy, do so.