TweetMyGaming caught my off-guard since I had never heard of it. The UI is a little busy but they are doing exactly what they intend. You can search for any game you want to see trending information, or just sit back and watch the live updating stream from Twitter based on keyword searches for games.
Down the right side is a list of the most talked about games, with a trending graph for the past 24 hours (default), 7 days, 30 days or all time. It is a good site for gamers to see what game is hot right now.
Just in the time I wrote this post, I was amazed at the real time stream as it scrolled at a decnt rate, letting you know plenty of people are out there gaming away.