In my opinion, there are seldom any roles that are highly overvalued.
However, I would fathom that any role that is multiple layers of separation away from execution is going to be what most people allude it to.
For example:
Product Management, is abstract in nature and the output isn't very tangible. Thus, people not intimate with their work will likely. yield to overvalued connotation.
Similarly, Management Consulting suffers from this as well. With the addition of high consulting fees and intangibility, it is perhaps the classic example of a perceived overvalued job.
This also applies to fields with significant complexity.
Think of jobs like Investment Banking, Quantitative Analysts, Data Science etc.
Since they deal with complex data and subject matter. Their work may not be easily understood by those outside their field, leading to perceptions of overvaluation.