Was thinking about this the other day from the perspective of running your own paid relay and certain (or all) notes would only be posted to that relay.

As was said already, once someone has access, to my knowledge there is nothing stopping them from sharing with others or rebroadcasting a note to their own relays.

But the initial distribution would be limited to only users who have access to your paid relay.