In the early stages of the game, I find pickpocketing together with stealing rather rewarding. The problem is, there's only one real hub with sufficient NPCs and houses to loot. Later on it's just one horse towns.