I don’t usually play sports games because i prefer to play actual sports but my buddy who rides enduro MTB with me loves Riders Republic. He plays it every time the weather isn’t conducive to riding.

I was a big fan of Excitebike. I should see about getting a copy of that again.

Also Paperboy.

Descenders is an extreme downhill trail bike game, it's tons of fun. The sequel is coming soon but first one is currently on sale for $6.25 and absolutely worth it.

Maybe not the vibe you're seeking exactly, but thought I'd add as a general recommendation

Lonely Mountains: Downhill is a low poly third person camera downhill mountain biking game in the spirit of Ski Free where you progress and unlock stuff by improving on your past runs in specific ways. Great vibes and a lot of fun to come back to repeatedly. Really captures that "sketchy" feeling of descending on single track.