I want to determine the most fit hardware requirements for ASP.NET MVC application that serves 1000 users. Including load balance, web servers and database servers.
You can go with Azure app service or VM with load balancer. Please check below URL and from where you can identify what is exactly needed for your purpose.