Is there any way I can watch Rockets games on this thing? Also, can I put music and movies on there from my computer wirelessly from my computer (not streaming, the actual files)?
No, can't watch them because no Roots app and also No TNT. But there's an NBA league pass app but you have to live outside of Houston.
Yes, you can stream your own movies and music to the roku - there are several options including Plex and also the native Roku Media Player. If you install the Roku app on your phone ,you can also stream files from your phone straight to the Roku.