I don't see any of them as competing with each other and enjoy them all. Currently running Leap and Fedora on different machines but have also spent years on Tubleweed.

Some questions... Do you want a rolling release? Do you prefer stability / uptime or having the latest packages? Any preference on AppArmor vs SELinux?

Most conservative and stable = Leap

Latest packages (at the potential cost of stability) = Tubleweed

Fedora for me sits in between the two. Newer packages but still requires the semi annual system upgrades for the major stuff. Every once and a while regressions or other bugs pop up, but mostly stable.