With a massive screen such as the one on the Samsung Galaxy Note, chances are it's going to be used to play some pretty sweet games. On-screen game controls still take something away from the gaming experience though, and while there are ways to use controllers, it's never the most elegant way of gaming.
One thing we can never accuse the Android community of, is a lack of creativity. What we see here is a bit of a homebrewed effort at creating a portable games console using a Galaxy Note, a PS3 controller, and some bits and pieces. The results are pretty impressive, and just goes to show what a bit of desire and creativity can do.