I was going to mention Fatal Frame. Silent Hill is the scariest on the list to me; Bioshock doesn't really strike me as a horror-type game. It has elements of fear and survival, but eh, I wouldn't classify it as a horror game necessarily.