There are a lot of AAA and indie focused single player experiences, what kind of genres are you into? The recent Tomb Raider titles are pretty good for example.
If you like big single player RPGs then boy are you in for a treat...
Single player gaming is better than ever, and even a lot of the "indie" titles probably have bigger teams and budgets than games from whatever "golden age" you're probably thinking of.
