I found one in Istanbul [0] (which now 404s) that somewhat fits the label and looks like it could have been a set on The Wire, but most of the "drug den" ones are just cramped, taken by someone who doesn't know how to take pictures and doesn't care to learn (blurry, bad lighting, noisy, poor staging), or both.
Most of the bad TV placement ones are also boring because they're just over a fireplace. Technically correct, but not noteworthy. However, I did find one that was truly spectacular [1] (still live for now) and left me with more questions than answers.
I feel like floor mattresses, trash, and peeling paint were also at play. They're all sort of unsafe rooms people wouldn't want to go to unless they felt like they had to (i.e. doing drugs)