While I can see native web3 NFT projects using this for metadata (esp cc0 ones that want developers to build on top), I suspect as NFTs reach mass market adoption, more traditional creators will opt for either a centralized solution where they have more control or a time-tested (but dumb) storage solution such as IPFS or ARweave.
What would make Tableland more appealing IMO is focusing on dynamic reference data from verified producers. Specifically, they could build infra to support the automation of reference data (via listening to on-chain events) from a curated set of on-chain data providers and enable builders to query/join against it. For example, imagine if Tableland was the best in-class way for builders to access ETH address->ENS lookups, a detailed list of active liquidity pools along with metadata from Aave/any DeFi protocol across chains, or NFT collection floor price data from OS -- with a defined SLA that was near real-time. In many ways, this is similar to Spec's vision although the approach would be more user-owned and less SaaS.
Re: optimal architecture, I drew out the web2 and web3 stacks -- and to Jesse’s point, what's most noticeably missing from web3’s picture is a decentralized, performant layer for data availability. While a database is naturally the first thing to come to mind, I’m not convinced that needs to be part of the stack. I actually think most web3 dApps will end up using a hybrid model of a centralized application-optimized database for user/app (off-chain) data, and utilize on-chain for data that requires public accessibility and immutability. The layers where I think opportunities exist are 1) caching and 2) APIs. The same way that smart contracts and on-chain data enable on-chain composability, the idea would be to build a user-owned, sufficiently decentralized PaaS protocol to facilitate permissionless composability of off-chain data:
Perhaps this exists already and I’m unaware? Either way, designing this is technically non-trivial given size of data, latency, mutability, personalization, etc — but where I believe the opportunity in the stack lies (and would help web3 fulfill its potential).