I've been self-hosting since 1999---first with a co-located server (perks of working at a small web hosting company) and now with a VPS. I host not only my own email and web site, but also DNS, SSH, gopher, gemini, and qotd. It's not as much work as you might think. But what works for me might not work for others.
Same, since 1999. My thoughts are if you did all this stuff before it got cloudy out, it’s already a routine that’s second nature/familiar and switching actually looks way more of an undertaking with way more risks. I could see how those coming to it later just became cloud native in a sense and never did the full admin stuff, so it looks equally risky, cumbersome and laborious