The difference between single player and modern HoMM (it’s a thing!) multiplayer is absolutely stark. Entirely different games, basically.
I like to play my own challenges now for minimal leveling; not formal ones for speedrunning purposes, just running more often and not grabbing all the resources. Due to the exponential nature of the game, generally if I do throw in the towel and level, by definition, the best place to grind is the latest possible place. Numerically you actually aren't missing out on much by trying to speed through the game and stopping only when necessary in most games.
Hero stories need to have a satisfying end, and I don't think many ARPGs acknowledge that this is even possible or design to allow it to coincide with the end of the story.
I imagine an ARPG designed to _end_ characters would level-gate content in such a way that unlocking, and defeating, the final content would be a satisfying end to the character. You would certainly be encouraged to start afresh, NewGame+ style, with a new character but it would be made clear that the character at the _end_ is also _finished_. Completed. Over. Done. The hero has finished their journey.
Ie, lock the character and have them just lounging around in a hub/town for your new characters to see.
RPG mechanics are generally meant to minimize the impact of player skill. A Skyrim stealth archer doesn’t benefit from hitting the enemy in the head, instead aiming is closer to target selection and their perks determine how well placed the shot was. This actually simplifies game balancing because players can self select challenges based on their character’s abilities. Though Skyrim also includes a difficulty slider, it’s not meant to offset endgame gear.
Dark souls is generally considered difficult because the RPG elements are minimized. Speed running the game doesn’t require people to hunt down a huge list of gear it’s just not that important.
You can lean into it, like Disgaea, which just embraces the brokenness and writes them into its mechanics. You can just sort of write a standard game, but then, in the end, the solution to all problems is grinding. You can scale the challenges with the level, but then, what's the point of leveling? In fact all you're doing is running the risk of showing just how busted the mechanic is when you have a hard time matching the levels correctly because of the exponential power gains; see Oblivion, for instance. And even after such a mismatch, the solution to all problems is still grinding.
Obviously many fine games have used this and I still play some to this day, so I'm not saying it's never ever fun. I'm just saying, the ways in which it's kinda broken seem fundamental and there seems to be only so much you can do with them. Were I designing a game today, rather than treating it as a default as so many designers still seem to, I'd want to take a careful look at the disadvantages and be sure I'm comfortable with them before proceeding. And as a gamer I do have to say more and more I'm starting to mark a game using level-based mechanics down a point when I'm figuring out what to play.