But won't you still need a decent private indexer with usenet or are paid indexers with open registration good enough these days? I've been using an invite-only indexer and haven't tried any other indexers in a while.

Not sure, I haven’t used Usenet myself but some friends do. From how quickly they were up and running it seemed to be less effort than getting into good private trackers.