Why would one need Software Collections?

What you are referring to applies to RHEL since what it includes is only what Red Hat can support commercially. Debian is not a commercial distribution and the same constraints don't exist there. Similarly for Fedora, you don't need external repos for development typically. It includes everything volunteers are interested in maintaining. None of repos you mentioned are even compatible with Fedora.