@anikeaten also this part "When it works, I don't always know why." is part of the learning curve I guess π
sometimes shit just works.
and the "when things go wrong, it takes hours to fix"
not sure where things go wrong specifically, but
1. snapshots are awesome
2. if possible, try not to work in a destructive manner, especially when snapshots are not an option. make a copy of the file you're editing before your changes, so you can easily revert back to a before-state.
@anikeaten here is an excellent two part beginner selfhosting guide by @ironicbadger
Part 1 - Hardware, proxmox install
https://youtu.be/zngSuqCM4d8
Part 2 - Remote access, Disks, Docker, Applications
https://youtu.be/guHoZ68N3XM
https://github.com/tailscale-dev/video-code-snippets/tree/main/2025/2025-06-self-hosting-part2
in part 1, check the pinned comments for a small change to the proxmox installation instructions

I also self host, but I don't have any easy answers, unfortunately. Like you, I often struggle. There's hours of research and learning before sometimes even simple things work right. Other times, complex projects come together quickly with minimum fuss.
For me, though, that's part of the fun of self hosting. I rather enjoy the process of figuring it out, of embracing a challenge. I know that's not the answer you're looking for, but maybe it can help.
I'm currently hosting my own email, mastodon, nextcloud, and wireguard vpn. I'll probably do more in the future.