Been using a Sixaxis for the longest time because I haven't bought a Dualshock 3 and have a BC PS3 so I haven't used rumble in a while, but I generally agree that for the most part it's kind of just... there. Doesn't add much at all.
--
http://img.imgcake.com/SonicStacking/anteaterfamilypissedjpgug.jpg