Not sure what self-hosted cdns there are that are good, but you'd need a decent server if you ever want to serve video files (maybe nowadays this is more of a non issue). I use cloudinary to host my media files I post on nostr, they have a free plan and API that I want to implement in alphaama to do exactly that