Yes, yes, and yes!
I have had mine for a while now. As you say, you can stream from practically anything including Windows based PC's.
In addition to this, you can rent just about any film, subscribe to just about any TV series, use Youtube, flikr and the like.
One caveat though (from which I suffer) You do need a pretty fast BB conection to take full advantage of all fetures!