I have the TNT2 32mb w/ tv out. I play dvd's through it and used to play every game from oldschool warcraft1 to Unreal tournament.
I have always been sketchy on Diamond cards. I've heard bad things about the drivers for them and compatibility with directX. But i cant testify to it.
Nvidia is on top of the Video card industry. Id go with the TNT2.