Fable II was more disappointing than the first Fable (although I played the hell out of the first one, but I just beat the second one and moved on).
Oblivion is good, and probably wouldn't be a bad choice by any means.
My favorite game by far is Mass Effect, not just out of these 3, but ever...