Rockstar wins it for me, by a longshot. The GTA series, Red Dead Redemption, Bully, The Warriors. Sure they've made some bad ones too (State Of Emergency. Yuck!) but they are usually few and far between.
I was considering L.A. Noire to the list of good games, but that was more of a Team Bondi production right?