There are rumors that there is possibly a coward trait coming in the new game pack, but this isn't about speculating whether or not we'll get the trait, just what we'd like to see with it. So what ...
They'd probably be afraid of the dark and other innocuous things that wouldn't faze regular sims. It could get annoying if they're afraid of too many things, though.