Ha, reading through this list, every time I thought of a game, someone would beat me to it. I'll echo the praise for the Jet Set Radio games, Beyond Good and Evil, Time Splitters and TWEWY but to contribute something to the discussion...
In terms of pure atmospheric awesomeness I'd nominate Metroid Prime (Phendrana Drifts - http://www.youtube.com/watch?v=ZbbUv1hz6mE ) and Jet Force Gemini (Water Ruins - http://www.youtube.com/watch?v=ji8OG3KwoHA and the epic title screen music - http://www.youtube.com/watch?v=gt8v1jV5uMQ )
But for pure cheesy happy awesome music I would have to go with the soundtracks to Snowboard Kids 1 and 2 on the N64. My favourite track? Probably Night Highway ( http://www.youtube.com/watch?v=3PStxslJ7Ks ) or Sunset Rock - http://www.youtube.com/watch?v=_cPWbTWBP1U )