I have not found a lock yet on a door or chest that has stopped me from completing a quest because I could not open them. I have found locks on doors that blocked an alternate path in a dungeon. The few locks I did have to open were low level and no problem.
I've found many actually. Many of the radiant quests require you to find an item in a locked chest. Sometimes I can find the dungeon key, sometimes I can not or there is not one. The necessisity is not really the problem here, however. The problem is there are no
reasonable alternatives to lockpicking. No the tower stone is not a
reasonable alternative because it is a one a day power, not something you can use actively in a dungeon to open 7 different combinations of chests/doors.
The alternative to that was Morrowinds way. You just click, click, click until the lock opened or you ran out of picks. Or, you just got a message saying you could not open it.
I'll be honest, I liked this better as it did incorporate only my character's skill and not my personal real-life skills. Bethesda's spin on this now seems to be to make the lock-picking game so easy that a 2 year old could do it. Thus is born my 40th level all powerful mage ... and great lock picker.
You sir, hit the nail on the head. Sadly a game made a decade ago by the same company had a better system in place. At least it incorporated my character's skill level in lockpicking.
Because guess what? Right now any character I make, starting at level 1 can open a master level lock in Skyrim. Not because of my lockpicking skill but because I've mastered the lockpicking mini-game. So has most people who played this game. It shouldn't have to be that way. Give us an alternative to lockpicking like we used to have in Alteration, and make the lockpicking action actually dependent on the skill level/talent tree like it used to be and you will have happier customers.
One last thing, to all the people who complained that alteration open lock spells made lockpicking obsolete, well you could only make that argument if you couldn't open a lock with lock picking that you could with spells.
Why do you care if a mage can open a lock just as you can? He has to level the respect school of magic to be able to use those high level open lock spells just as you had to level lockpicking to open yours. I see no problem here until you start removing game content. It's the lack of RP options and immersion that is the root of the problem here.