Regarding Bester, if you're up for a good read I'd recommend the "Psi Corps Trilogy". Three books by J. Gregory Keyes which detail the beginning of the Psi Corps, Bester at his prime and then what happened to Bester after the series. They're very nice.
Back on topic, what's with all the hate against Stargate?
I love the series. And while I admit Season 8 isn't quite what I'd hoped, for the most part, its not THAT bad. I've been enjoying Stargate Atlantis. One has to consider its only the first season. As for the game, I hope it turns out to be good, but considering most games based on TV shows or Movies, I'm not going to get my hopes up.