Like others have said, PS3 is the best option. The Sony exclusives are amazing single player experiences, and at least in the us they are quite affordable. For example, uncharted trilogy is like Indiana Jones, with the second and third games being amazing, Last of Us has an amazing story and gameplay, and God of War 1 2 3 are really fun to play.

Also, you have a large catalog of non-exclusives. My favorite single player campaigns are Bioshock, Call of Duty Modern warfare (1,2,3), COD Black Ops (1,2), spec ops the line, red dead redemption, and GTA V.