Silent Hill 2 and 3 are magnificant. Valkyria Chronicles has a good soundtrack too. Heavy Rain has some magnificant pieces. Also, if you count Visual Novels as games, then Clannad's soundtrack is a masterpiece