The Elder Scrolls are the biggest one I can think of, aside from MMOs. I wish I could think of more, but you're making me want to re-install Warcraft 3 because its ORPGs were so awesome... even if copying the save codes wasn't xD.
Unfortunately, I think Warcraft 3 still owns the market in that regard.
I'd say Mount & Blade Warband is NOT quite what you're looking for, due to its emphasis on raising armies.
EDIT: Oh yeah! Sacred 2: Fallen Angel comes to mind as well, and it's EXACTLY the ORPG formula used in Warcraft 3 games, but on a MUCH larger, more open level - The wide open map of an ORPG (I think it's HUGE), with the control scheme of a Loot'em'up. But now that I think of it, its loot system's pretty... wonky.
The first Two Worlds game, if you can get over the horrific Voice Acting, is also another good ORPG - except that you end up depopulating the world because of a complete lack of respawning enemies. I think the Gothic series works as well, but I've not had enough experience with them.