Im intrigued by this too.
In the long run, I'd imagine consistent and inconsistent players would provide the same true value to the team (in terms of generating wins).
But over the course of a single season, a steaky player could possibly make or break a team depending on when their streaks occur.
Would it worth paying a slight premium for one over the other?
Another question would be, is inconsistency consistent (i.e. are streaky players forever steaky, or is it mostly just perceptual biases)?