A top level difficulty which is unbeatable would keep players like me interested in the game indefinately.
I'm not a "cheater" or "hacker," I'm just looking for a personally challenging game to play: challenging = fun, non-challenging = boring.
Agree totally, and that is usually addressed in modern games with multiplayer options.
In Age of Wonders the longevity of the game was not created by improving the AI (which is decent but in the end, solves its main problem, the sovreign's vulnerability, by just keeping him in the city with tons of troops.)
The longevity of AOWSM was acquired by developing an effective multiplayer system. The devs of that game soon realized that people don't sit through a game for hours when they start losing, because as time passes the winner's turn takes more and more time, while the loser's side is reduced to move a couple of units and then press the end turn button. I wrote a long post a while ago, explaining why Play By EMail is the only option that is ever going to work for multiplayer:
Players get their turn by email and send it to the next players: no long boring sessions, no need for players to all find the same time frame to play, no need to wait for the other to end their turn (I like to watch my empire and take my time: that's part of the fun) -
An Epic game can only be carried through with PBEM. I can state that for sure because I have played MANY games one hour a day for a year without anyone complaining. Besides that way the loser, while a bit annoyed doesn't take long to end his turn and doesn't have to wait for me to end mine. (Having more than one game started at the tme gives an extra motivation for losers to start their PBEM session)... And then surprises DO come: sometimes a side that looks like it is going to lose suddenly recovers and amazing things can happen! All that wouldn't happen with regular multiplayer because people are used to singleplayer games where you mostly progress straight to victory, and they get "bored" as soon as something goes wrong.