I've used Final Cut Pro (Apple) since version 1.0, and the Final Cut Studio is a very powerful suite of products for the money. Honestly though, if you are considering buying a Mac for any reason at all, I would say try iMovie which comes free with the system pre-installed. It's not nearly as fully functional as Final Cut Pro, but if you're just looking to cut home videos to music and transcode to a web friendly format, why spend the extra $999 on software with more features than you'll ever use? Or try it free, then upgrade if you need more power.

If you need to stick with the PC and need a little more power with editing functionality and creative options, then the Adobe suite of products is very good as well. Premier for editing and After Effects for compositing/visual effects.

Just my 2¢.