The only long-term value I see are DRM-related things like reselling digital assets, artist compensation, etc. Other than that, mostly greater-fool scams and signalling for the tech elite.
The 3 in Web3 is just there to wipe the slate clean in order to resell just about any original vision that previously failed.