Unpopular Opinion: Oblivion's lockpicking is better than Skyrim's. Yes, it was tedious as hell but I'd argue that's the whole freaking point, especially if you're RPing as a Thief and/or Assassin :
How will Lock picking work in The Elder Scrolls Online compared to previous titles - Stratics Central