If you get Dance Dance Revolution make sure you get a good pad (like Konami's official one...there's better ones but they get pricier, the most expensive was $2,000 for an arcade replica I think)...I got a bootleg one from some underground mall in NY (oddly I couldn't even find a Konami pad in Flushing). You got to be careful cause they slip and slide real easily and all that shit. And the buttons break too. So far I ain't had no problems with mine's in about 3 years but I probably only spent around 20 hours playing it total so...
I haven't really been keeping up with video games in the past few years (except for certain genres that interest me, like sports/fighting, as well as the 'best games' through word of mouth) so I don't really know about the good games that no one talks about (ie Prince of Persia I think)...but The Bouncer is good. It's worth a rental at least and if you can find it at Circuit City it's $5 (probably all gone by now). I don't think they even carry it in major retail stores anymore aside from EB Games/Gamestop.
NBA Street 2 is hot, me and friends always played that game (and the first) without any arguments (except who was better).
http://www.gamefaqs.com/console/ps2/
There's a bunch of games up there but in different genres and stuffs.
Top rated games by Gamespot
Most popular games by Gamespot