Outside reddit:

  1. Women are more attracted to loud obnoxious guys that quiet ones
  2. Women prefer guys who ride dirt bikes, than those who dwell in libraries.
  3. Women are turned off if he doesn't have a typical 'bro' social circle
  4. Women prefer 'streets smart' wit over nerdy 'intellectual' humor
  5. Unlike men women are put off by introverts as a romantic option

The shy bookish underdog being the real 'fantasy' of women is a Hollywood trope mostly. I witness how every month: girl breaks up with her jerky ex (usually a kickboxer, footballer, athlete) says she just wants a 'good guy' who is more 'open minded' and likes feminine stuff, yet she ends up hooking up with his best friend/cousin (also a kickboxer, footballer, athlete).

Most of the time it isn't really good looks that makes these men so attractive; it's the typical masculine bravado they display. Women being (in their own words) more of social beings than men means that they're more prone to abide societal conventions: this means the man she picks must look 'cool' not just from her pov, but he must be seen as 'cool' by other women, even society at large.