It would be great if they made lockpicking in real time and make broken lockpicks make noise which will attract unwanted attention to you.
That way lot of those perks in the tree will start to make sense and become very useful and worthy of spending perks on.
Real time lockpicking crossed my mind too. I think it would be cool to have this, but on the other hand, I can imagine it would make lockpicking virtually impossible in some scenarios. Like when I want to avoid killing guards or killing in general. It would most certainly make the player use more tactical thinking like in those stealth games (Splinter Cell, Deus Ex, etc...). Observing movement patterns, diverting attention with an arrow to the wall, stuff like that.