Yes, it's a parody. Cliches piled high. Half the cliches are taken seriously, and the other half are parodied or deconstructed. That's the whole point, right? Kazuma has to be an otaku shut-in because that's the formula for these shows. He picks up a sword and teams up with a woman with magical powers, again, because it's the formula. And when a goddess asks him what he wants to bring with him into the other world, is anyone surprised by his answer?
The part where the show shines is how it takes itself seriously even when the whole concept is ridiculous. If adventuring is a job, would you get sick of it, and take up construction work instead? If you're a team of ill-suited newbies, what kind of adventurer would be crazy enough to join you? Can succubi coexist with humans? How can a headless horseman sleep with all that racket?
The good--the humor. The characters are perfect for comedy. Great animation. The show is fast-paced and fun. Kazuma's deadpan response whenever someone says his name.
The bad--if I never see another anime where women talk about breast size it wouldn't be too soon. Full, full, full of cliches.
Basically, if you have any kind of nostalgia for fantasy RPGs or adventure anime, and you want something that's made of pure fun, this is the show for you. If you want something a bit deeper, or if you think it's too childish to watch girls get their panties stolen, then pick something else.
