I have not seen any Red indicators on any door I have tried pick the lock on in a town. However, those doors are probably owned like the rest of the building is. So, perhaps someone "owns" those doors in a dungeon.
Or, perhaps this counter is just for any door you lock pick. Heck, it could even be any lock like on a chest, but I would imagine you have opened more than 22 locked chests in this game.
I don't go through chest as often. Deimos is only lvl 8. And I try to limit my game
-Rarely fast travel [unless companions aren't showing up no matter the wait]
-Do not loot a lot of the chest
-Do not take all the gold and jewels, only enough to buy spells
-Do not pick up every weapon
The only thing I do not do is DID.