Elder Scrolls 3 is fun as hell if you go deep.
It's single player... but it's got great story, and super immersive. And, it doesn't have a lot of recent Bethesda-isms bogging it down.
Still probably the best fantasy-setting game I've played. I find myself replaying it often, even though the graphics are dated.
As for MMOs... Honestly, DDO has kinda hit the sweet-spot for me. I haven't found another one that appeals even half as much. The only other one I (
infrequently) play is DC Universe Online. But, it's very much a set-path - even if you have a fair choice of paths to take. You pick a Hero/Villian mentor (
Batman/Lex Luthor/etc), a weapon (
lots and lots of those), and a Power (
again, lots). After that, you are on-the-rails for a good while. But, the stories are very pulpy/super hero, well written and voice acted. It's a good diversion when I need to take a break from DDO but still want to scratch the MMO itch.
Good luck to ya. Hope you find a good place to recharge, and you come back to DDO refreshed.