Best Hosting Options for My ASP.NET Core and Blazor App?

I'm looking to host a web application that includes an ASP.NET Core Web API for the backend, a Blazor web app for the frontend, and a database that will likely be either MS SQL or PostgreSQL. The database will be small with just a few tables, and the app is mainly read-only (though there might be some CRUD operations happening independently of user actions). I'm aiming for about 500 unique visitors per month, with a strong possibility of scaling in the future. I'd like to know what hosting solutions you recommend that make it easy for me to deploy and update the app. Additionally, I'm hoping to find a pricing plan that is fixed rather than pay-as-you-go, to avoid unexpected costs from things like DDoS attacks or bots crawling my site.