Seeing as how your all about MW2, your taste in games is probably incredibly mainstream and unrefined. Regardless of your lack of taste, i will list some amazing games you will probably hate for all the wrong reasons.
Uncharted 1 and 2
Little Big Planet
Dragon Age Origins
Devil May Cry 4
Metal Gear Solid 4
Ratchet and clank
Street Fighter 4
Please note that NONE of those are first person shooters.
If it seems like im acting as if im better than you, its because i am.
If you havn't heard of most of these games, just dont bother. Sell your ps3 for an xbox and play shitty first person shooters all day.