I thought this game seemed decent when I played it for the "All N64 games in one video" video, and I went back and played it recently to give it a chance. It starts off pretty slow and easy but gets very fast-paced and crazy after cup 3 (called "level 3" in the game's campaign, which goes by the title of "Big Game"). As you progress, the bikes get faster, there's more traffic, and cops join in. You also get a selection of cooler weapons.
This footage only took about 40 minutes of play to achieve, that's how wacky this game is.
It's not a feature-rich or polished game by any means, but as far as gameplay goes it's a blast, especially in multiplayer. The physics are really fun and impressive. It also runs smooth in hi-res mode which is always a bonus for an N64 game. Definitely recommend playing this if you haven't before, it's in my top-10 favorite N64 games now.
PS: This is the first video I've uploaded using my Dazzle and Amarectv, I'm pretty pleased with the quality.