CentOS is RHEL, just without the branding. SLES and openSUSE share the same core packages. So you get the stable, well tested enterprise stuff.
LEAP is exactly the same package versions as in the newest SLES I believe. I would expect them often to be a bit older package versions than Fedora, but I haven't compared recently.
Tumbleweed is a leading/bleeding edge rolling release distro. The closest equivalent is Fedora Rawhide.