The two main places where you'll need lockpick are specific chests and locked doors around the map. You'll only have the option to open most chests with lockpicks, but for most locked doors ...