I have a hard time figuring out the right balance for my side projects, too. I've used Heroku for a long time, and it used to be the best offering period, there wasn't any competition about it, but lately offerings like Render and Vercel have been compelling alternatives.