I checked my PS3 today and felt bad for the poor fella. It's grey from all the dust.

So, I'm gonna give the little guy some love. I'm thinking of buying a DualShock to somewhat offset my hatred of the Sixaxis.

What games work with rumble? I know Uncharted does (as do newer games I imagine), but is there anything else?

BTW, the new PS Store is pretty nice. I didn't have even one urge to throw up in my mouth while navigating through it like I did the old store. 

well all of the games I tried were dual shock enabled,,,this list includes:

Heavenly sword
uncharted
army of two
R6vegas2
assasin's creed

Blast Factor*
Burnout Paradise
Resistance 2
Condemned 2: Bloodshot
Devil May Cry 4
Dragon Ball Z: Burst Limit
Dynasty Warriors 6
Folklore*
Formula One Championship Edition*
Go! Sports Ski*
Gran Turismo 5 Prologue
Gran Turismo HD
Heavenly Sword*
High Velocity Bowling
Lost: Via Domus
Metal Gear Solid 4: Guns of the Patriots
MLB 08: The Show
MotorStorm*
Pain
PixelJunk Monsters
Piyotama
Ratchet & Clank Future: Tools of Destruction
Resistance: Fall of Man*
Snakeball
Super Stardust HD*
Tekken 5: Dark Resurrection Online
Timeshift
Tom Clancy's Rainbow Six Vegas 2*
Toy Home
Turok*
Uncharted: Drake's Fortune
Warhawk*

taken straight from wikipedia. * is an update for the game is available to add the rumble function.

Not sure if this is a complete list, but here:

Formula One Championship Edition* (PS3)
MotorStorm* (PS3)
PAIN (PSN)
High Velocity Bowling (PSN)
MLB 08: The Show (PS3)
Uncharted: Drake's Fortune (PS3)
Resistance: Fall of Man* (PS3)
Ratchet & Clank Future: Tools of Destruction (PS3)
Go! Sports Ski* (PSN)
Folklore* (PS3)
Heavenly Sword* (PS3)
Warhawk* (PSN / PS3)
Super Stardust HD* (PSN)
Snakeball (PSN)
Toy Home (PSN)
PSOne Emulation (PSN)
Piyotama (PSN)
PixelJunk Monsters (PSN)
Blast Factor* (PSN)
Condemned 2: Bloodshot (PS3)
Lost: Via Domus (PS3)
Tom Clancy's Rainbow Six Vegas 2* (PS3)
Burnout Paradise (PS3)
Dynasty Warriors 6 (PS3)
Devil May Cry 4 (PS3)
Dragon Ball Z Burst Limit (PS3)
Turok (PS3)

*Titles that require patching for rumble functionality.

http://www.us.playstation.com/PS3/About/Controller/Controller_games.html

That are more games than I expected.

Motorstorm has it? Awesome, I already have that game.

Moor storm has a good one actually If you hit the car on right only right side will rumble ,same thing with the left...

Is that done often for rumble controlers?I mean seprate the vibration for each side of controller ?

My biggest disappointment with DS3 is that its not enabled in Hot Shots Golf:OoB. You'd think that in the year since HSG's launch in Japan, they might have added it. My biggest surprise is how useful it is for MLB 08 the show. When the pitching cursor disappears, the only way to know if you are out of the strikezone is by feeling vibrations. Also if there is a runner on 2nd or 3rd, the rumble simulates a heartbeat (nervousness for the pitcher and excitement for the offence.)

@RocketPig
I answered your Warhawk question in the Leagues thread instead since the information can be useful to anyone yet might not get seen again once the wishlist thread dies. (I hope you're still active in this thread to read this)

wheres the cod4 rumble ...