I have noticed that with a few notable exceptions, it seems like enthusiasm for "Web3" seems inversely correlated with web development experience. The conclusion I draw from this is that the longer you've been building web apps, the more concerned you will be that nobody can explain how these "Web3" apps could possibly work at scale, or why you would choose a "Web3" stack when your problem case doesn't explicitly require it.
For the optimists, I really want you to think about this when you go to sleep tonight: if larger smart contracts cost more than smaller smart contracts, it's a forgone conclusion that developers will skip type and boundary checks. Do you really want to bet on a future where developers are perversely incentivized to write code that is easier to exploit?