Archers - RD. Double Bow, Shinon, no contest. Paladins - Can't really think of a game with poor paladins since the two you start out with usually end up pretty good. I guess SS? Franz, Forde and Kyle were all just good. But it did have Seth... hm.
I don't know personally but it would have to be a game where the enemies are generally tougher and the player characters are generally weaker, because the only reason archers are even considered "bad" by anyone is this "hurr you should be killing everything in the enemy phase and everything that can't do that is utter crap" mentality.
So obviously, a game where you can't kill everything in enemy phase, and attacking the enemy is more dangerous. Um... Shadow Dragon Hard 5?