I have been through the same problem. I tried shared servers, Cloud, Dedicated, and VPS but they all have some kind of limitation like inodes, I/O, pricing, etc.
I used Digital Ocean and It's best for small and medium projects who don't require much storage space.
Then I found the servers. You can build your own like Digital Ocean but they don't have any limitations.
I set it up and now I have 200GB of storage, I am also storing images and big PSD, and Vector files so it requires more storage.
It is fast and also cheap like 8USD per month but giving me speed and optimization like Digital Ocean. My site is very heavy and still giving me 3-5sec or loading time.
But overall in my experience, these kinds of hosting are the best self-managed VPS servers.
I tried 2-to 3 Self-managed servers but found only 1 working best for me because I had a backup of the website of about 40GB.
More Computing Power for Less | Award-Winning Support from an Actual Person - not a Bot! | 9 Regions, 12 Locations | 99.996% Uptime Over the Last 12 Months
contabo.com
You can try this.