How is the big elephant in the nostr room tackled - the expensive rich media content hosting?

Before this is solved there’s no mass influx of people familiar with regular social media. Pics are cute but videos are the norm.

P2P, self-hosting on your G, One or Apple drive or something else?