Yotsuya-san
Senior Don Juan
A lot of sci-fi provides wish fulfillment fantasies for nerds. Take Hiro Nakamura from Heroes. He is a loser geek who becomes a (no pun intended) Hero and gets the girl and becomes cool. Sci fi is full of characters who would be otherwise dorks but are considered cool in their sci-fi universe. A lot of science fiction, particularly "hard science fiction" has scientists and brainy types as the hero. Usually, in the written sci-fi, such heroes are not described as looking like handsome movie stars but plain looking (this is very common with female sci-fi authors and their characters). It's sort of a revenge against mainstream heroes who are always conventionally good looking, brave, athletic, macho, everything that the nerd can't be without not being a nerd anymore.
The harem anime (Tenchi and Oh My Goddess) is most definitely wish fullfillment fantasy for nerds and wapanese.
The harem anime (Tenchi and Oh My Goddess) is most definitely wish fullfillment fantasy for nerds and wapanese.
