Crimson Dragon on Xbox 360 (the version with Kinect controls) was finished. It got accidentally listed very briefly on the Japanese Xbox Live Arcade marketplace after the final build was uploaded and passed certification. This probably counts as it wasn't intended to be an official release.
It wasn't like the other Fable games though, this was Fable Legends. I love all three original Fable games but Fable Legends just never looked that interesting tbh.
Fable Legends was also pretty strictly a multiplayer game. And at least going by what I played at GDC, another core difference from the other Fable games is that it actually seemed to be at all good.
From what I hear, the game was basically in a state where they were polishing and adjusting balance before it got canceled via Lionhead being offed - it was effectively release-imminent.
Some mentions here aren't complete unreleased titles, but rather cancelled during very advanced development stages.
Welcome to modern game development. If a game has online functionality nowadays, you can expect it to release during early beta and be patched up later.
Only completely-offline games really have a chance at releasing "completed."