okay i am gunna sound so old rn but i grew up playing on a ps2 that was my first video game experience and i had all sorts of games (mainly racing ones)
the two that had the biggest impact on me and that in my opinion have the best soundtracks would be Flatout2 and ATV Offroad Fury.
these games feature heavy rock or metal music such as Rob Zombie, Korn, Nickelback, Audioslave, and i believe Motley Crue. as well as some lesser known artists.
The game ATV Offroad Fury starts out with an opening cutscene of real world atv riders performing amazing stunts as the song Atlanta by Strawhorse plays in the background. this opening scene alone is so nostalgic to me and always reminds me of the more simple times of being a kid in the 2000's
https://youtu.be/xDj4UI503_w?si=xBXgHCir8r1CVDWV&t=50