As for how this scales? I have no idea. I'm just speculating that it's gonna happen somehow. I mean, hell, look at this post - a nation adopted Bitcoin. You think that's the last time a government will experiment with crypto? China is already developing their own fiat cryptocurrency. You think it's just gonna stop?
I don't necessarily want this to happen, nor am I advocating for it. It's just a prediction, so I'm now sure how to answer your questions.
Smart contracts backing more real world assets has a slightly higher chance of becoming a thing, but even with those the value isn't super clear. The whole idea of tracking ownership is that it's backed by authority to enforce it, and the whole idea of cryptocurrency is that it works without authority.
If you think NFT you think about that vague thing that has no bearing on the real world. Bitcoin is the magic technology that manages to be scarce and be manifest in the real world despite being fully digital and networked. Ethereum managed to one-up Bitcoin with the smart contracts of which the DAI stablecoin which anchors itself to the real world currency without relying on authority.
NFT's basically are the exact opposite of the sort of thing cryptocurrency offers as value to the real world.
Just where exactly the title itself is stored? I would assume it's a at least moderately long plaintext file, describing property and conditions. Maybe some authenticity attributes, like digital signatures of multiple parties. Where do you think is this artifact located? Inside the NFT?
Also, there's no reason why the property and conditions have to be stored together; they could readily exist as separate artifacts sharing some ID or reference.