This is a messageboard. Rants occur. Carry on.
Ok then!
Assassin Bad name choice sure, but still a cool class, since his spells facilitate his sneakiness. I've used one as a villain and it went over very well!
Devoted Defender Sure anybody should be able to take a hit for an ally, but I'm not trained to anticipate danger and throw myself in it's path. Not everyone is gonna be good at doing just that. Plus the devotion that it takes is immense. Can and would you take a bullet for someone? Are you fast enough to jump between them and death! Ask a real bodyguard what it takes to become one, I know one personally and it takes serious training to be truly good at it.
Dungeon Delver The rogue is not a trapfinding specialist, it's a jack of all trades! The dungeon delver just focuses his skills to one avenue of adventuring. That's like saying a ranger is stupid because he's good at killing orcs when any fighter could do the same and take better feats while he's at it. While we're at it why don't you bash the Arcane Archer it's just a bow weilding fighter with spells!
Forsaker If you roleplay a forsaker by carrying around a bag of potions, you shouldn't be playing a forsaker, in fact you probably shouldn't be playing at all. I have played one, as a barbarian similar to the old 2nd edition barbarian that hates magic. It was fun.
Frenzied Berserkzer Fantasy stories (some of the best) are filled with characters who can't control themselves. Not to mention comics (Incredible Hulk) and movies. It's a great fantasy character if played well. Once again I've actually played one before.
Heirophant Gee the ability to manipulate magic in a new and rare way. Spells are mere tricks to what a well played Hierophant or Archmage (which is an Arcane equivilent) can do. It's narrowminded min/maxing that can't see the potential here. "I don't want to give up my spells for those abilities." Then, news flash, don't play one.
Red Wizard of Thay Okay so maybe it's only really good as an NPC prestige class. It was still fun when I used them in my Forgotten Realms campaign.
There, rants happen!
I've seen every one of these classes in play except for the Red Wizard and the Hierophant, (but I've played an Archmage which is just the arcane hierophant.) All of them have made memorable characters. I accepted a long time ago that not all material in books was written for my personal enjoyment and that there exist a large variety of playing styles. The writers don't cater just to you.
In the end it's not about what you play but how you play it.