Think Wiimote, but way better motion tracking. Resistance 3, Heavy Rain, Child of Eden, Puppeteer, Sports Champions, some dance games for the wifey (Just Dance and some other title), Tumble (you stack blocks. Sounds stupid as hell until you play it.), I think all the PS3 RE titles, and some kiddy minigames for Sly Cooper Collection. Pretty sure there are more I own that are Move-compatible.
For shooting, excellent. Only game I had issues with was Heavy Rain, I suck hard at the Move controls for that game. Some of the Move controls are brilliant - like in Puppeteer the 2p can control the companion, collecting stuff and messing with the environment. I haven't played a driving game with them.
Edit: here's a list. I'd say a good number of those titles are shovelware, but some surprises. Didn't realize Bioshock Infinite used Move!
http://en.m.wikipedia.org/wiki/List_of_PlayStation_Move_games
