No know can tell you what hardware can fit for you.
Because why?
Its depend on your :
VPS Hardware
Connection speed
Customer location Base
Wordpress Plugins numbers
Server-side Caching
Your DOMAIN DNS speed ( yes may you never think about DONT BUY FROM NAMECHEAP - google or AWS or cloudflare )
Web level caching - redis object cache - php opcache
Server running with what operation, which web server software will be using? what other software installed the server? I hated control panel plus php my admin, those are sucks your vps ram.MAnage your vps on CML
So list goes to MARS
One more,
Please tell me which cloud provider are you talking about those hardware 10gb ram 5vcpu your vps server.
I tell you real cost of those hardware with internet speed and bandwith
Real vCpu 5
Real 10GB Ram all no shared with others
2gbps net 5tb bandwith
it will cost around 100-150USD per months, so do yourself math
What im trying to say? all the cloud provider not big one ( Google,AWS )
lying all people and people dont know what they get for them money. Like you.
When you rent a virtural place in some computer, you are renting with 20 to 100 people together.
Those hardware are Big cloud provider giving you direct virtural resource. Not like shared cheap vultr linode or other check the price panel if no additional segments says dedicated resource then yes they are also tricking you
Go to google cloud and check the compute price and information they have two plans one is shared one is full dedicated resource.
Same as AWS, Digitalocean too.
So even you setup Lemp stack no control panel, no phpmyadmin everything managing by hands and install wordpress with few plugin you code your theme, one day one guy ( your neighbor

) will run a SQL query 30 seconds your all website will gonna freeze like dead corpse
so what you can do?
Amazon Cloud start to give people 300 bucks for 1 year you can registired and create a ec2
or google cloud 300 bucks giving for 3 months. try them. Install everyting manually and hardering your sever and web.
Install Those stack
Ubuntu 20.04
LEMP
Fail2ban
redis
php extends
opcache
ufw
WPCLI
wordpress plugins etc etc
hardening your server and wordpress
NO Postfix NO Control Panel NO PHP MY ADMIN never..
After you did everything correctly You will have decent speed and your server will not handle so many times because of the caching if the request came directly to your server can handle 2500 CONCURRENT USER yes same time amazing right?

but for be sure do load testing and open on CMLI htop with top and check the results.
good luck