I think teh best 4 characters for a party is... the 4 characters the players want to play. It,s true a blaanced team will allow to do much things, but it is a lot more fun to play what you want.
And for survivability of the Rogue, having played Rogue since a long time, I would tell that it can survive as long as any other if played well. It is just some people go with his Rogue into bracket into each combat, and search every room and try to disable every trap... that is suicidal.
Combat Expertise and improve feint allow the rogue to stay on teh same side of the Figther and Cleric, and thus, raise his survivability. try to use social skill to get around combat. No combat, no dead... Not everything have to be search, and if you search all, you can sometimes just pass next to the trap without disabling it, or simply trigger the trap from a safe place (summon monster and ask the monkey to open the chest...).
A group I like is much:
Paladin, Cleric, Wizard, Rogue.
The Paladin is a bit less good in combat than a figther, but haev better saves and can heal, a good backup when it is the cleric who fall.
The cleric is the healer by excellence, and if you have many combat, you need healing. He is a good second figther.
Wizard, for more flexibility in the spell list than any other arcane caster. Make him archer, and his feat of archery will apply to all ray spell too (fun to cast ray of enfeeblement on teh Ogre without touching your Paladin).
Rogue, a trapfinder by excellence, have many skills, and can do a difference in combat with his sneak.
Paladin will have high Charisma, Cleric and Rogue should have Average. Wizard can have average or low. So except the wizard, everyone will have some social ability, which can allow you to go around some combat. The cleric will be the best placed to have a cohort and should get a Bard (He will boost everyone, can be a good archer to support teh team and can heal if needed).