Saw this on skyrimnexus and it is quite well done. If you are interested give it a try and some love. I'M NOT THE AUTHOR AND AM IN NO WAY RELATED TO THE MOD.
This is the description:
This mod aims to make lock picking harder, but also more rewarding. In the base game, pretty much any lock can be picked at low skill, and with only two perks (golden touch and treasure hunter) that give any real benefit, the skill tree is pretty much useless.
List of changes:
Lockpicks: Weight increased from 0 to 0.2 and price increased from 2 to 5. Removed from random loot except for bandits and forsworn, but general goods vendors should offer a few more now.
Lockpicks break much easier on all lock levels, but increasing the lockpicking skill will now counter this effect (at 100 skill, you'll be back at vanilla values for breaking).
Sweetspots have been reduced to one third of their original values on all locks.
Perk changes compared to vanilla:
Novice - Expert Locks (Renamed to Manual Dexterity I to IV): Make locks 2/3/4/5x easier to pick and increase critical chance with daggers.
Master Locks (Renamed to Careful Intruder): When inside, entering sneak mode allows you to detect anyone nearby for 20 seconds.
Quick Hands (Renamed to Burglar): Able to pick locks without being noticed and all locks are twice as easy to pick when trespassing.
Wax Key (Renamed to Manual Dexterity): Gain +15 unarmed damage and all locks are twice as easy to pick. Disabled when wearing heavy armor gauntlets.
Locksmith: Added Wax Key effect.
Unbreakable, Golden Touch and Treasure Hunter are unchanged.
The lockpicking bonus of Burglar and Manual Dexterity stack both with each other and the novice/apprentice/adept perks.