A guy with a tiny cock, struggles getting a girlfriend: scares them off all the time, and is a general asshole
.. to put it simply. The term however can be used very generally, and applied to any situation, or person.
1. Girl1: Wow! that guy is such a creep
Girl2: Yeah! What a snood.
2. Guy1: That Alex guy is such a snood..
Guy2: Yeah I know man.. He pissed on my sisters birthday cake.. what a snood-y thing to do