The rumble is finally coming to Sony PS3 consoles in the United States. Amazon.com is shipping the wireless Dualshock 3 controller tomorrow April 4th for $54.99. You can of course pre-order today.

Sony published a site listing compatible PS3 games where you can enjoy force feedback as we all know it from the PS2.

Dualshock 3 compatible games include MotorStorm, Formula One Championship Edition, Resistance: Fall of Man, Gran Turismo Prologue, and many more.
Several of the games will get the rumble compatibility through an update from PLAYSTATION Network. So keep your PS3 connected when you first play a game with the DualShock 3.
See the Sony DualShock 3 page for all compatible games.
More details about the Sony PS3 Dualshock 3 Controller on Amazon.com.