I watch all my FLV files with Media Player Classic.
If you're running Windows and want an idiot-proof codec pack, uninstall everything you have, reboot, and then install CCCP. It's not quite as clean as getting all the individual codecs you need yourself, but it's simple and will open everything. I mean, I could watch FLVs in Windows Media Player if I wanted to with this codec pack.