We went with Hetzner as we already had good experiences with their VPSes. For this particular db migration, a resonably sized VPS with volumes does the job for us. We don't have planet scale operations so the lowish IOPS is not an issue atm. Also, with this experience at hand, I am confident that we'll manage another migration if need be.
Afaik Hetzner has a couple of server locations in the USA. Is it correct to say that Hetzner has to comply to US CLOUD Act and therefore give away any data requested?
do you use FDE on your hetzner instances? I couldn't find a guarantee that they properly dispose of block storage so I ended up developing a utility for this https://github.com/mvelbaum/hetzner-fde-toolkit
Did the exact same thing for a client who's ops we managed on AWS. I was pretty against ditching RDS and a load balanced setup for hetzners load balancer and 3 instances (2 web, 1 db) but honestly, it's been pretty smooth sailing. The sites faster, and costs dropped massively, saving the client approx €900/mo for a better service.