The one click is really geared for rapid testing, if you already have an existing project it’s probably best to setup the VPS manually.
ClearDB isn’t actually one we support, Heroku offers PG and there is also a 3rd party add-on for MariaDB from Jaws. (But I agree it’s not a good choice)
Yeah windows performance in production will be quite slow.
Vultr, Linode, DigitalOcean Apps (we have a webinar tmrw about this: Strapi Meetup: Building Fullstack Web Applications on Digital Ocean App Platform | Strapi ), AWS, GCloud, ect.