As someone who worked for years in video transcoding, archiving, streaming, and content management in general: there are absolutely ways to do this efficiently in a self hosted context. You could absolutely build a system that fits your bespoke needs in all of these categories.