I find there are styles of music that don't grab me, and of course there are marquee players associated with those styles. But even in the styles that I'm good with, whether a given player "inspires" me will depend on the tune, but also on what aspects appeal to me on that particular day. FWIW, I like Eric Johnson a lot and have about a half dozen of his albums. But even with him, there are segments where I am prompted to think "Oh jeez, THAT riff again? C'mon man, you know how to do other stuff."
I rarely, if ever, find Jimmy Herring uninspiring. That might be because I'm only familiar with him in contexts that bring out the best in his playing.
And some players can seem uninspiring at first blush, but when you zero in, and maybe even slow them down, it elicits a "Wait, WHAT? How did you DO that?!" reaction.
I've loved Frank Zappa's playing since the mid-'60s when I first heard Freak Out, but even he can be given to mindless noodling in search of a good phrase. So he has his inspiring as well as his uninspiring moments.
I think most players have their moments where they're in the car, idling, waiting for the good phrase to come out of the store.