Bodie going down was probably the hardest death to take the whole season. But like he said, "you're not going to put me in one of those abandoned houses!" BLOWE BLOWE!
yeah the writers were really successful, at least from my perspective, in creating an (almost) respectable person out of a drug dealer. I never had a soft spot for Stringer, as so many viewers seemed to have had (admittedly most of them probably female). but Bodie's inadvertently issuing a death sentence to his boy Kevin, the raw frustration at the crime scene when he kicks in the patrol car windows, his final conversation with McNulty, and his defiant exit, all combined to make for a pretty tragic death. you really sorta had to agree with McNulty when he said, "you're a soldier, Bodie."
oh, and Bubs' defeat at the hands of the street was truly sad. things were finally looking up for him in a way.
no other show (or Wire Season for that matter) has so successfully portrayed hopelessness; this season brought so many characters so close to redemption: the kids, Bubbles, Colvin (again), only to have it snatched away.
the parallel "reform" arcs from Season 3 were in some senses tragic as well: Colvin's attempts to reform the cops and Stringer's attempts to ratchet down the violence in the drug game. but Stringer was, ultimately, a drug dealer. and Colvin lives to fight another day in Season 4.
in Season 4 on the other hand the victims were not really horrible people, nor seasoned vets, but kids. you really get invested in Randy's future over the course of the season, only to see him runied basically.
like Bubs said it was crazy for him to try to pretend he was anything other than a dopefiend. in Season 4 the viewer feels crazy for ever thinking the school or political systems can ever be changed either. pretty hopeless.
I guess the shows producers throw you a bone with Colvin and his wife adopting Namond; all is not lost. still one-out-of-four kids is pretty bleak.