I vaguely disagree. The support heroes are more fun because they have utility. DPS heroes generally do not. That’s why it is fun to DPS with support heroes.
Supports also protect their teammates better than most tanks. That’s likely why a lot of garbagio support players exist. They are the more fun versions of DPS and tanks because they get abilities that actually do something unique.