There are a couple more I happened to run across, this one just seemed really on the nose about what generally will happen if you try to hide in your house. It reminded me of our conversation.
In another of them, the girl had a warrant and tried to refuse to come out of her house so she wouldn't have to stay in jail for the weekend. Long story short, she got arrested and more charges. That one, they didn't have the ability to enter the house without a warrant, they just had the arrest warrant for her specifically, so they were waiting for a judge to sign off on a warrant but were able to talk her into coming out before the warrant came through.
There was another where the guy was hiding in a closet inside the house. They didn't have a warrant, but they did have probable cause to enter the place, so long story short he got arrested even with the hiding in the closet part.
Your summary of how it works, way way above, was actually pretty accurate (warrant or emergency being the two main exceptions to the general rule that they can't come in your house). The thing is that about 90% of the situations where they're coming to the door and are planning to arrest you will fall into one or the other of those categories. You gain nothing in the "they just want to talk" situation, and you gain nothing in the "they want to arrest you" situation. These are just some examples of people who tried to solve the problem by not interacting physically with the cops, and then it not working to accomplish anything positive.
(Again, this is only for local law enforcement, and only if they are generally aboveboard. For ICE or federal law enforcement, or if you're not sure, I think not answering the door is probably smarter at this point.)