Totally agree. As cliche as it sounds, I wanted the fight to feel more "epic." I was expecting something borderline unfair/aggravating...either Alduin has an insane amount of health, uses a whole bunch of shouts against me (us), he summons help in the form of other allied dragons; something tricky. I realize adapting the battle to a HUGE range of player characters is nearly impossible (level scaling, gear, build, tactics, etc.), but if anything, Alduin fought like any other dragon that rides the small bus.
And there's the rub. I touched on this in my post, and suggested some relevant improvements, but there's really no way to do it for the full range of power levels characters can attain due to the vast difference between the extremes. Any fight geared towards the 'twinked-out' characters will obliterate pretty much anything else, while those same characters will walk all over anything aimed at less powerful characters.
One possible answer, although I know some folks will hate the idea, is to borrow a page from fighting games and have the
AI itself scale. In these games, the higher the difficulty the faster the AI reacts and the better it handles its move-set, often to the point where you need tournament-caliber skill just to keep up. Now, I don't suggest ramping things up
that far, since
Skyrim isn't meant to be brutally difficult, however if the AI recalibrates itself according to the difficulty setting and the player's power level then it would always provide a challenge. I don't know if such a thing can be implemented or not, as I don't know the AI's architecture, but I would imagine that at least
something along these lines should be possible.