Why wouldn't you right? You're passing up so much loot if you don't!
But yeah, I'm an obsessive packrat in those games, pick up anything not nailed down/not considered stealing. So you know I write down the locations of any locked stuff beyond my level to go back and get it later, even if it's just a lunchbox or some shit lol.
most games struggle to balance the value of all skills. holds true for Bethesda games. I've never found lockpicking to be worth.