One time I did have an officer pounding on my door at 0 dark thirty, something like 2 or 3 AM...he was there because my phone was turned off, and my mother had passed away. My brother had called the local PD to check on me and let me know what was going on. I was armed, but the officer never saw it, plus he both identified himself and stepped back into the light from the porch light so I could see his uniform. I keep forgetting this one time it did happen to me - we tend to block bad memories, maybe?
In that specific case, the officer was polite, respectful and expressed his condolences as well.