It is a wish fulfillment fantasy most of the time, that’s why I really appreciate series which go out of their way to deconstruct that aspect of the genre, like Re:Zero or Tate no Yuusha no Nariagari. Especially Re:Zero, which shows what would actually happen if you put a shut-in NEET loser otaku into a fantasy world.