In no particular order:

Tom Clancy's Splinter Cell
Metal Gear Solid
Resident Evil
Silent Hill
Spider-Man

Most of them are in series, so it's hard to pick my favorites from these, but most of their sequels are outstanding too.