My gut says low number of upvotes are probably indicative of a "thing people don't know they need" opportunity.
Can't imagine there are too many 100+ upvote use cases that don't already have substantial competition.
So 10-100 is probably a sweet spot in terms of "people are interested" and "there's an unfulfilled opportunity."
Obviously a TOTALLY different league, but I have a small text editor plugin that got < 10 upvotes, and how has 500,000 installs. don't think I ever posted.it anywhere else.