That's a very fair question, and it got me thinking. So I wrote a full post answering it. But the short answer is, as long as you don't have to twist your architecture in knots to get high performance, then yes it's worth it. A system that can scale up, can also scale fast & cheap.

https://spacetimedb.com/blog/okay-but-does-it-need-to-scale