Try it. It costs 0.004 EUR/hour for the cheapest VPS, so you can try it for a few days for pennies. I used a VPS for 396 hours and got billed 1.52 EUR. I used a couple of cloud volumes too, which are free until December 6. Then they will cost 0.04 EUR/GB/mo, and I believe they will be charged hourly. + VAT. The only hitch is that you need to trust them with a credit card, so they will charge you automatically every month, according to your usage.
I’ve used another company’s VPS with LXD before. It worked fine, but I was limited by the 10 GB disk. I could reliably fit a Ubuntu container and a few Alpine containers, in “dir” storage backend. I also tried to use it with ZFS on top of files. I could launch a few Ubuntu containers, because of ZFS sharing between them, but I ran out of disk space at unpredictable times (e.g. when I did an apt-get upgrade, or when I deleted images).
I currently have a dedicated Hetzner auction server with 40 running containers (50 total). Some of these are test containers, e.g. install some software in order to evaluate it. I use 800 GB of disk space (mostly videos and photos from some events, that I share with nextcloud). 800 GB would cost me 32 EUR/mo (+VAT) in the Hetzner cloud. The dedicated server is cheaper. In the meantime Hetzner launched Nextcloud servers for 7.90 EUR/1 TB/mo, so perhaps I could move my media files there (it’s not clear to me how), and replace the dedicated server with a few VPSs + cloud volumes. The economics of servers keeps shifting as new products and services come along. It generally gets better and cheaper, although occasionally some companies raise prices.
LXD provides a big advantage in this quest for the best option: It makes it easy to switch hardware and companies, because you can easily move containers between hosts, either by using “lxd copy” between two live hosts, or by exporting the containers as images and then importing them on another host. I used this to move my containers from a dedicated server temporarily to a VPS with attached storage (ceph - slow), so I could rebuild my dedicated server (upgrade OS, replace the software RAID with mirrored ZFS) and then move them back again.