Is there a reverse kind of catfish where someone pretends to be way less hot than they really are, and get off on that?

Only, they won't be considered catfishes as no one will be paying them attention.
They'd be humble or have self esteem issues.... they're surely not getting off on going invisible. 😂

You mean a dogfish ?

Yes