The best rpg games like Fable II are Fable, Fable III and Kingdom Come: Deliverance II. Below are 9, each with the reason it is here — and, at the end, what filtering to rpg costs you.
Filtering to RPG means you want progression — a character to build or a party to grow — layered on top of whatever else you liked.
What you get: A reason to keep going after the novelty wears off. RPGs are the genre that reliably converts hours into feeling more capable.
What made Fable II worth playing in the first place is covered on the full list. This page is the rpg part of that answer, and only the rpg part.
The first one, smaller and stranger, and the one people quote.
The follow-up, if you want the ruling-a-kingdom half.
A world that reacts to your reputation, played completely straight.
Reputation with factions as a real mechanic, and much funnier.
The other great British-feeling fantasy RPG.
If what you wanted was the marrying, the house and the life.
Mid-budget RPG where faction reputation genuinely changes quests.
Immersive-sim RPG where consequences follow you across stories.
A place that remembers what you did, over twenty-five years.
Immediacy. Almost every RPG asks for a slow first few hours, and the systems that make hour forty good are the same ones that make hour one a menu.
The full list is on games like Fable II — 9 picks, no genre filter.
Fable. The first one, smaller and stranger, and the one people quote.
No. Fable II released on the Xbox 360, but a recommendation is only useful if you can play it, so the picks above span platforms and eras. What they share is the genre and the reason.
Whether the stats are the point. In an RPG the build decides what you can do; in an action game with stats the build only decides how fast you do it.
No. The picks below span turn-based, real-time and action RPGs, and each one says which it is.
By hand. Each pick was written for the full Fable II list first, on what the game actually does, and this page is the part of that list that is rpg — never a genre tag lookup, which is how "best racing games like Super Mario 64" used to be a page on this site.
Or read the rpg guide for where to start in the genre generally.