Alas, the answer is the unsatisfactory "idiom." There is no rule which will tell you which words combine with which prepositions, and which prepositions carry which shades of meaning when so combined. You an be consumed by fire or consumed with passion for the opera, but you can't be consumed in.