Does Sitefinity Cloud support automatic Sitefinity upgrades?

Yes. An automated process runs daily checks for updates and executes a step-by-step upgrade routine. You're duly notified via email and have full control over when to merge and promote the upgrade.