I think Forgejo is great. But we need to remember the fact that many enterprises pick GitHub or GitLab because they provide paid support and SLA. Also Forgejo Actions are still in beta, while GitLab and GitHub are pretty established solutions for CI/CD

Sourcehut is basically a really barebones web interface for git server, so I don't think it's really comparable to GitHub

For hosting your own projects that's sometimes not a viable solution either. Limiting your open source project to platform other than GitHub hurts it's discoverability, because usually GitHub is what most devs and non devs associate with open source. I heard a lot of "It's not open source if it's not on GitHub". You can mirror your project to GH of course

"Just migrate to X because it's faster" doesn't work that well in the real world

My forgejo-server ran on a broken fiber for a few weeks - we're talking about speeds in the single kilobits/s. It kept up fairly well!

Pushes and pulls would still kinda work, actions not so much (but that's cause it needed to transfer more then 100MB)