The memespiracy investigation has already more than proven itself to be a fruitful and worthwhile investigation, judging by the many indictments and convictions it's racked up. The Stormy Daniels issue, however, is definitely a wild goose chase, because none of it will matter in the slightest. Trump supporters don't care that their hero had an affair with a porn star, and they absolutely don't care that he might have broken the law in covering it up. And Trump will not be indicted or impeached unless a number of his supporters turn against him.
To be fair, this isn't something exclusive to Republicans. Clinton was probably saved during his own impeachment by the fact that most of his supporters simply didn't care about him lying about his affair.