pazZzurro: I know OP doesn't want to talk about JRPG's, but really I mostly find dungeons in those games more memorable and more dungeonly all in all. I feel one has to think hard to find something either very bad, or for that matter explicitly good about dungeons in WRPG's. And still this mostly applies to the RPG's of yore – from the 80's and 90's.
I could talk about JRPGs; it's just that this topic is not about them.
Back to WRPGs, I do remember one dungeon from Might and Magic: World of Xeen that's rather obnoxious, but fortunately optional. Namely, the Dungeon of Death.
Level 1 is a crossword puzzle. Basically, you go around this level and answer questions about the game. There's no real action on this floor. I think there is a reward for clearing it, but it's the only meaningful thing you get for this dungeon.
Level 2 is home to some very nasty enemies, particularly one common one that can eradicate your party members. (Eradication is a condition worse than death, and curing either involves paying a lot of money (in a game where money, not XP, is the limiting factor for leveling up at this stage of the game).) The level does have one nasty troll, but at least it's funny. (Just remember to save often, so you can reload if that happens, and fortunately a certain spell can warn you about this.)
Level 3 is a maze, where there a piles of treasure that you need to jump over; if you touch one of them, the level resets. Thing is, at this point, you're really hurting for money, as you don't have nearly enough money to get the levels you qualify for, yet the game teases you with piles of treasure that you can't take.
Level 4 is interesting (won't spoil it here), but is unfortunately lacking in rewards. There's a common respawning enemy that is easy to kill quickly (provided you have a certain item), and which provides a lot of XP, but XP is useless without money, and again the game fails to give you any money here. Sure, you'll get a quest item as a drop constantly, but that item is useless, unless you're doing a *really* unusual playthrough of the game (as in, going out of your way to make this drop matter). Also, since it's a quest item, you can't even sell this item for money. The end isn't that interesting, either.
Of course, I could also mention the final dungeon of Swords of Xeen, where the only weapons that work on the enemies there are not accurate enough to hit them reliably at the expected level, and offensive magic doesn't work at all. Then again, Swords of Xeen is basically a fan mod that got a commercial release, and it has many other issues (like fountains that can cause integer overflow/underflow or be usable to raise stats infinitely, not to mention unreasonable difficulty spikes).