It's not supposed to be scary. It's an RE4 clone, with slightly better gameplay and monster design.
It has a better story.
Now, I know that's not saying much, but DS' story was actually entertaining for me. Don't expect anything brilliant but it was much more interesting than "The President's daughter has been kidnapped by zombies. Are you man enough to save her?".
As bad as Resident Evil's plots are,
isn't any better. The end cutscene is pretty fun, though.
Finding out
was a pretty good twist to me.