I grew up with most of the Apogee catalogue but didn’t encounter this one at the time – I played it for the first time for a video that I did a couple of years ago, https://www.youtube.com/watch?v=kG8chy-kRRg#t=19m10s . I ended up really enjoying it and playing all the way through to the end! The 3D Realms Anthology came with the original DOS version at the time, but the Windows-ized version that comes with Steam is functionally identical and works a bit better.
It feels a bit short because all the tracks are theoretically open to you from the start and there isn’t much in the way of feeling like you’re progressing, just the same loop of signing up for a race. But once you’re over the initial hump of difficulty and have the hang of the game, it’s satisfying to work your way up the ranks. It definitely wouldn’t have flown as a “full” game even at the time, I think (it was considered a budget title if I remember right), but it’s a fun enough diversion.
One tip that I remember seeing somewhere is to always pick the Duke Nukem portrait for yourself, because this takes him out of the game and he’s the hardest opponent by a mile!