A weirdo, loser, freak. Someone you would not want to be seen with in public.
"I don't want to hang out with them dad, they're total Melvins"