I had problems finding out about Mac compatibilitiy. Now I make sure before buying.
In general, FireWire camcorders will work with iMovie/Final Cut but I'm not sure this extends to all. Make sure you get Mini DV, NOT MICRO MV AS THIS DOES NOT WORK WITH MACS. Sorry for the bold, but that had to be said. If it's Mini DV and FireWire, there's a good chance it'll work. My dad's JVC camcorder works and that's not on the compatibility list.
iPhoto: most things work. The drivers should be included with OS X - certainly any Canon and I think most Sonys. The best thing to do is
check in the shop before you buy.