No, I don't think people who live in houses they choose to buy, mostly happily, can be compared to fentanyl addiction. There is something essential lost in the simile.
The people who live in McMansion land do not consider them to be eyesores. That is why they keep getting built. I do not accept that a McMansion violating the aesthetic sensibilities of people who don't even live near them is a "negative externality."