i think it's still a great game, i love the mechanics, but it doesn't offer as much exploration and content as AoD did. you can progress in the game no matter how good or bad your build is, and everyone will most probably get access to the same, all, areas. that was a conscious design choice, certainly.
TBH while it has been almost 6 years to the day since I last played AoD according to steam, I have the impression that AoD technically allowed you to get to all these areas but lack of specific skills didn't allow you to loot/explore them fully, so you missed out on gear and skill points. A bigger obstacle to accessing the same areas was needing specific metagaming knowledge on where and how you can learn about some location to have it marked on your map. Both my suboptimal thievan archer (with random points in lore and some other crap, very messy and generalist build) and Optimized Legionaire Murderhobo Terminator aspiring (and eventually succesful)
god-slayer, could get to all of them, just not very deep in some cases.
But CS does seem to have more forgiving failure states and no CYOA rollercoaster sequences where you can suddenly end up in a fight or click on a "you died" choice, plus IIRC AoD did not have visible skill difficulty in dialogs. Usually you have full freedom where to go and if a fight or stealth section comes up you have a very clear warning from the game and option to fuck off and come back later. You also get plenty of non-lethal but sub-optimal outcomes if you can't deal with something, such as being able to betray and switch sides before some of the tough end game fights and "easy" fights rather than frontal assaults as an alternatives via a "I'm not much of a fighter" options.
Furthermore regarding progression regardless of how good the build is, I don't recall exactly how the path of least resistance to get to the end looked like in AoD's main quest regarding skill levels needed (and what skills), but that game was also clearly designed with the same "if you do like shit/your character sucks, the ending will suck and be beyond your control" philosophy as CS was. That was my general impression after Vince subverted my expectations with the AoD endgame, my very suboptimal Thief/Archer build had to choose to fuck off as the alternative was
to become a slave to an awoken god. In CS the "bad" ending is far less bleak, but it also does boil down to "you were a pawn with no say how things should be, despite all your involvement", leaving you with the same kind of feeling of being powerless.