Honestly, they generally don't go poof. I remember I had a VPS for more than 10 years with Hetzner. No poofing till they had to get rid of that offering. I have the backups but I think now I prefer just running on GKE + RDS for funsies. Costs a bunch (like $50/mo) but I don't have to worry about anything.

And fuck me if I'm ever writing a BIND zonefile ever again.