Questions are a good thing.
I can remember when the P7 was what many "in the know" wanted. I'm aware of at least one State Police Agency carrying them. A municipal agency of around 50is officers also issued them for several years. Yes they got hot quick. They can be extremely accurate and rather flat which aids in concealment. But the slide is short and so much of the weight is in the grip, especially with the P7M13 that finding a holster design the prevents the pistol from flopping around on your waist is a challenge.
Then there was the issue of the officer shooting themselves in the leg every so often. The P7 was one of those guns that it was recommended you stay with exclusively. Switching platforms could be an issue.
But the P7 has a cult like following. If I were to post this on the HKForums, there would be a hit team dispatched within minutes to find me. And to be honest, I wouldn't mind owning one as a range toy. The first time I watched the movie, "Die Hard", I walked out to the theater wanting to buy a hard chromed HK P7 and an AUG.
As for the weight, yes by today's standards, it's a heavy gun. But then so is a Beretta M9. When these guns were introduced, they weren't considered heavy. But then one was comparing the weight of the gun to a 5" steel frame 1911 or a 4" S&W model 66 or a 686 revolver. The weight issue is all a mater of perspective. I think it's funny to hear younger shooters gripe and complain about how heavy their Beretta M9 is, as I think back of carrying an issued 1911 as a young Marine. But then I have a Glock 19 on my waist as I sit here and contemplate the irony...