Dementium actually has a pretty boring story in my opinion; bland and is barely talked about until the end. There isn't much scare either besides seeing a new enemy or the medusa head screams.
In any case, the recently localized Theresia: Dear Emile is probably the scariest DS game out now...