The MGS titles used them to do the stick ups with the guns, the slower you press it the slower you raise your gun etc
Racing games could make use of them, with acceleration/decelleration based on how soft or hard you press but the Dualshock 3 had analogue R2 and L2 buttons so the acceleration...