My understanding is that those scenarios are the exception, and finding obscure contracts that have gone undiscovered isn’t really an untapped fount of free, missed, opportunity.
That said, aggregators like bonfire etc. can get you pretty far if that’s your strategy!