Fallout 3, definitely.
In fact it is the only game I've played with a lock picking minigame I've liked. The system in the original Thief games was also OK, as it was less about skill than time consumption (it didn't pause the game). Thief 3 had a system that was too easy to matter, the mechanic was similar to FO3 except there were only ever four or eight spots and your pick couldn't break. As with the earlier games it was more about time consumption, but it only took a few levels before I could open any lock extremely quickly, so the time consumption didn't really matter. Oblivion's system was, in my opinion, equally pointless but far more frustrating.
Fallout -
Very limited at begining.
You svck until you get to 50 point on lockpick.
You are limited in what you can pick.
Your 'force' option svckS
In this case I'd have to say that being limited is a good thing. It wouldn't work for all RPGs, but I think it's important that you need the skill to fully utilize it. In Oblivion the security skill is largely pointless as the mini-game relies far more on player ability than character skill. The Fallout 3 mini-game seems to be a good balance of player perception and skill level.
I can't comment on the force option because I've never needed to use it.
Oblivion -
You can take a chance at the 'very hard' locks even if it's 10 points
You have an equal chance on all locks
You can do any lock as long as you have picks.
It's fairly simple and isn't a puzzle.
I never found the Fallout 3 mini-game much of a puzzle. I do think it would have been helpful if you knew how large the regions were, but I don't know how well that could be implemented. Perhaps tying it to your perception stat instead of your lockpicking skill, it would be nice to have more times when your attributes stand out.
In Oblivion I quickly found that I just waited until I could get the skeleton key and would auto-attempt locks from then on. Even after I got the hang of the timing the mini-game did nothing for me. This further neutered the security skill, but since I already felt like it didn't matter I can't say I really cared.
In a future TES game I hope the mini-game is more like FO3's, although perhaps not with the skill requirements to attempt harder locks.