OK, the Ouya is an Android based games console that can also be used for multimedia, internet browsing, etc.
Apart from android apps and games, it can also run emulators to play games from older consoles, like the SNES, Genesis, etc.
It can also run a program called XBMC which allows you to stream videos from the internet or from an external hard drive, no subscription required, but a little tech knowledge is probably required to help set it up the way you want.
It might be easier to show you.
Ouya doing a bit of everything.http://www.youtube.com/watch?v=78XQHex71kg
Some games on Ouyahttp://www.youtube.com/watch?v=DM0FqpX2qbI
XBMC on Ouyahttp://www.youtube.com/watch?v=IoFbsJVietA
XBMC & Netflixhttp://www.youtube.com/watch?v=BisAw14I5iw
As far as being technically minded goes, the Ouya was really designed for people interested in creating games and apps for it. If you just want to just play Ouya games, it is fine, but for anything more it is suited more for people who are a bit tech savvy and like messing with settings, configurations, etc.
I can see it just being frustrating and confusing to those who aren't.