Relays are definitely in a unique position as they see the volume and have the most data to make decisions. Especially aggregators.
Client explicit filtering is hard especially for mobile devices. Explicit content detection for images may be ok, but videos? Not likely.
Client filtering based on keywords, pubkeys, kinds, lists, relays, etc - the more simple yet powerful stuff - makes the most sense.