can it be played solo against some kind of wave/horde enemy style?
also loved older Zipper Int. games who made this
It doesn't have a "horde mode" that I know of, but the regular game has a full campaign playable in single-player like Left for Dead, and with the DLC, you get a second campaign featuring some good guys that's also playable single-player. Basically, you pick four out of six people for your team, use XP to upgrade perks and unlock guns for selection upon level start, that kind of thing.
It's not the greatest game in the world, but if you want something that's kind of like Left for Dead, that might be your best bet on PS3. Level-based structure, "safety checkpoints," team of four people surviving against zombies, the only thing it has that Left for Dead doesn't have is the occasional living human with a gun and a third-person perspective.