Honestly, most “ugly” people can be reasonably attractive if they get in shape, eat healthily (especially in a way that clears up their skin) and style themselves (clothes, hair, etc) in a way that suits them. Plus finding good angles and lighting for photos/videos, and building up some confidence and charisma for in-person interactions. Those things aren’t necessarily easy and they take patience and commitment, but most people can easily go up a few points on an attractiveness/10 scale if they manage them.
I don’t think the Steam Workshop is the issue here. I’m glad it exists, and direct downloads or snv links are still a reasonable alternative for mods that can’t be hosted on the Workshop for whatever reason.