Being able to rape everything is fun for a while, but after doing it for hours on end it gets boring. If the player ends up being so powerful that he can rape everything without consequence halfway through the game, the player should be meeting more powerful enemies to match his power. Ie. if the player becomes a demi-god, he should be facing demi-gods. Being all-powerful is incredibly boring when there isn't any competition.
It depends on the player. In vanilla I maxed out my character and basically one-shot everything until the last map (where I was two-shotting everything), and never got bored.
That's why I was a little surprised (and angry) when I found out that in FoV the difficulty skyrocketed, and I had to use strategy to kill enemies fast.
Or there should be more of the weak enemies and they should have abilities that allow them to be more effective in large numbers and/or support a stronger 'leader' enemy. Then you get the best of both: killing enemies by the dozen and you still have a challenge.
And that's what was done in FoV. In most of the dungeons there were lots of normal level enemies (for example in the last dungeon you were getting attacked by about 10 level 40 enemies at once, and it was hard), so I guess the devs already knew this problem and understood how to solve it.
