Fedora is very changeable: a new version every 6 months and support for only 12 months. Often they can launch new ideas before they're ready. I remember when they were the first distro to use Gnome 3 and hardly any of the configuration tools were ready. Security is great, with SEL installed and running. It can be a pain getting the media codecs and other patented software, so it's really a good idea to get one of the respins that provides it all for you, like Hanthana or Kororaa. They do a lot of enhancements between issues, so it's almost like a rolling-release. I used to install the yum-security plugin, which enabled me to ask for security upgrades only.
CentOS is very stable, which is why it's the most popular Linux on web-servers. A lot of people will say it's unsuitable for a desktop, but that's rubbish. It is short on programs for the home user, though, so you need extra repositories. Be sure to follow the advice on their web-site and use the yum-priorities plug-in.
Oracle are not an company I'd want to be associated in any manner, shape, or form.