2
A cursory visit to gamespot tells me that it's basically a news site. You will need content modules, of which XOOPS has many. AMS, Content, Article, News, Mastop Publish... all have various strengths and weaknesses which you're only going understand by trying them out.
One or more of those, a download module and a video playback module... Yup, XOOPS could build you a site like this.
Your biggest problem (or not) is going to be all those templates and theme files that you'll have to customize if you want it to look anything like as professional as gamespot. So, if CSS and (x)html are your forte, time to get cracking!
Never let a man who does not believe something can be done, talk to a man that is doing it.