The notion of there being underrated or overrated distros is, itself, overrated. No, there should not (and cannot) be "one distro to rule them all" because different people have different needs.
Remember that in the free software community we have the freedom to modify and share everything. Those "overrated" distros exist because someone saw a need for them, and they are widely used because other people agree. If Debian was good enough for every use case why do these other distros exist? Why doesn't everyone just use Debian?
If you have a vague understanding that Linux has distros and to switch to Linux, you'll likely Google "best Linux distro." Results that say "they all are good for different reasons" are unhelpful. Having sort through 50 options isn't helpful.
New users want to know what to install. This means that some distros get hyped up as the best, and then people point out the cracks.
Until there is a clear and objective list of distros with pros and cons labeled the cycle will continue.