RedHat Enterprise Edition and CentOS are aimed for companies or professional users, where stability and reliability are top priorities. On company servers you usually don't have many nifty GUI tools available - often enough there is not even a GUI desktop installed. Installation of packages is restricted to a core set of tools specific for the given business.
Fedora on the other is aimed to the community, where people with very different IT skills and working concepts are gathered. Even a Fedora default installation provides a lot of tools, and it is up to the user to make the choice among these.
The core UNIX concepts and tools are basically the same, and the often mentioned 'bleeding edge' applies more to those tools that are not installed on company servers anyway. In the end you can configure RHEL or CentOS to be like a bleeding edge Fedora, or trim Fedora to be similar to RHEL or CentOS.
For private users I suggest Fedora, because it's more fun. Doing a full install (ALL packages) will give you a lot to evaluate, test and play with.