If someone uploaded a god awful addon, like a puke green cylinder for a hat, and it (somehow) got enough support to be unevitably added, would valve reject it?
Yes
Plenty of items that have had overwhelming support have been rejected, primarily for "not fitting with the game's art style" (which is bullstuff considering some of the items we have, but the point still stands)