I would absolutely use Hetzner for a real money-on-the-table business. You just have to know what you are up to and do your cost-benefit analysis.
I actually moved a business of ~100 FTEs from AWS to Hetzner once. Aside from the migration cost, the price was roughly 25% of AWS.
At the end, the biggest gain was not monetary, but human. For years, that business could retain skilled engineers who had the opportunity to work close to bare metal, caring about the nitty-gritty technical details of backups, failover and high availability.
And they did not even cost much. That they had so much leeway in designing the system instead of "relying on the cloud" was a major retainer.
I left many years ago, the business switched frameworks since then but they stayed on Hetzner.
P.S. Yes, that was before Hetzner Cloud became a thing )