So this question has been bugging for me for a while and I can't seem to find the answer to it.
Context
I have been a web developer for many years.
When I access a website, any frontend code is run in my browser, using the computing power on my computer. Any backend code is run on a different server. Any data is stored in someone else's centralised database. Some data is stored in cookies or local storage in my browser.
When I run a video game on my computer, the program is fully executed on my laptop (with the exception of some data probably being pulled from a database, e.g. if I use Steam).
Alternatively, platforms such as 'gaming as a service' would move most processing power onto a server.
Question/s
Ethereum is described as a 'World Computer' but how does this relate to traditional architectures:
Is the blockchain element like for example a Wordpress database, with smart contracts being like my server side code? If this is the case, is that code only executed when I make a call to it (like with Lambda functions on AWS)?
Is Ethereum therefore just a distributed serverless architecture?
If a platform was to be built like 'gaming as a service', I'm guessing that I would be drawing processing power from millions of computers in the network? (I'm also assuming that this is part of the current debate about scaling).
In 10 years, if Ethereum is where we hope it will be, would it theoretically be able to support much more processor intensive use cases such as gaming as a service, or is that never the best use case for it?
Thanks