Resistance 3, Killzone 3 and SOCOM4 in that order with the sharpshoter. All were great fun. And resistance 3 was truly fantastic.
RE5 is also good except you shoot with the Move button which is a little strange (so no sharpshooter), but it works well. Goldeneye works ok, but is a step down from the ones previously mentioned. Haven't played MAG as I am not big on multi-player.
My biggest disappointment to date (despite wanting more games) is that co-op is not supported with the Move for most games. RE5 did it, but you can't use the sharpshooter. Would love to get 2 Sharpshooters going in co-op. That would be awesome.
For non shooters I would say Heavy Rain and the Sports Champions games. Infamous 2 is supposed to work well, but I have never got around to it.
Personally I am looking forward to Beyond, Bioshock Infinite and the patch to Portal 2 which looks great. I have some hope for Dust514 and Star Trek which should come out in 2013. There was talk of Aliens Colonial Marines supporting it but that has gone cold recently. Would love to play it with the sharpshooter.
Haven't played one with Move for a while and would love to again. Need the right game though.
I agree with dmmp1234. Once you adjust to move ( and sharpshooter) the better it is and it becomes very hard to go back, especially for shooters. Trying to aim now with the dualshock just annoys me because it is so slow and inaccurate in comparison.