It depends obviously of the use case for your node but as far as I know, Bitcoin software links 8 peers together everytime.
So in fact, public instances can handle high requests but private node instances won’t serve millions of users. Btw a node well configured should be fully able to serve such demands