I found the holy grail - GP Bikes from Piboso. No other bike game I've ever tried, going back to 1998, comes close to this. It feels SO real. It's also the only one where the cockpit view truly works well (aside from some of the really arcadey ones of course).

There's a demo for it too. I'm running it with an Xbox 360 controller and it's amazing. They also have a dirt bike game too, very hard at first but I'm getting there...

Someday I want to run it like THIS