The first game I tried with my new Dual Shock 3 was Half-Life 2 in The Orange Box. Much to my suprise and disappointment there was no rumble! There were no options that I could find to turn it on either. Looks like the PS3 version is without rumble and from what I can tell there are no plans to add it. 
