It's great. I also self-host my own Forgejo (that's the software Codeberg runs on) instance for private repos, to avoid using up space on Codeberg's servers.

Main problem is the lack of federation, leading to splintering across Codeberg/GitLab/sourcehut/self-hosted forges. I know there's Radicle, and Forgejo is working on ActivityPub integration, but it's slow-moving to get what should be inherently federated by design (git) to actually be federated. In practice you need accounts on a dozen different websites if you want to regularly contribute to foss.