I've had a the smallest cloud instance for a few years now, it is in fact really good and fast. 1vcpu with 2GB ram is plenty for a full stack web application + a database. IO is also very good with stable ~8000 iops write performance for 4k sync. Compared to Azure VM instances, Hetzner offers like 100x more performance for each $ spent.
Can your App scale across regions?