After dinking around in Terraria for about 10-20 hours with my wife... I got pretty bored with it. She kept playing for probably another 20 hours after that before I picked it back up again with some mods this time. Ended up putting another 50 or so hours into it with mods and that made it a pretty excellent experience. If you can get it on PC, go for that. Games like Terraria, Minecraft, and Don't Starve are all made even better with mods because imo, the vanilla experience gets pretty boring pretty fast.
I watched the trailer for the PS3 version, seems like it have some stuff more than the pc version did.