Heroes should certainly be larger than life, hence GURPS PCs are 100 point characters rather than the 25 points considered average. However, if they (or their players) alter space and time at will that is not "triumphing against all odds," but against NO odds, automatically. AD&D lent it itself so much to that it had to introduce level-draining enemies to inhibit or even reduce overpowerment; unfortunately, it was quickly nerfed to the point of irrelevance by various forms of Restoration.

Heroic characters should have exceptional, but still limited, abilities. They should be capable of amazing acts and accomplishments, yet within a fixed framework, because that is what makes the achievements impressive, memorable and therefore FUN. If characters are nigh-omnipotent demigods, what is the point?

Baldurs Gate actuall offers a good example: The battle in the Iron Thrones HQ, or even those in their Cloakwood mines, provided me far more challenges, thus fun, thus lasting memories, than bumrushing dragons and vampires in SoA. I have almost NO memory of ToB, because by the time I reached it my characters were all so powerful they destroyed pretty much all the bosses instantly, from start to finish. One of my best memories of the series was the first run through Durlags Tower, because no combination of low saves, AC and THAC0 allows you to short circuit a comples series of traps and puzzles (which it seemed like Bioware largely phoned in for SoA and ToB, though the Big Metal Unit was a nice bonus for anyone who played the whole series and could find all the components.)