I currently own Resistance, Armored Core 4, Rainbow Six: Vegas, Call of Duty 4, Half Life 2: Orange Box, and Unreal Tournament 3. Out of those games only Resistance and UT3 have rumble, but its only good in UT3, since in Resistance the only time it goes off is when you get shot.
PS. I also own Guitar Hero 3, but I didn't include it in the list, well, since I'm never going to use the dualshock for it.
__________________
|