Sony SMP-N200

Pros: Easy to set up, familiar PS3 interface, proper sized box, no wierd shapes or hockey pucks.

Cons: Remote is a tad sparse, audio issues.

Summary: I took a look at what was out there and ended up buying the Sony and haven't regretted it. Having used a PS3 before I found the crosshair style interface easy to navigate. Unlike other streaming box manufacturers, Sony has decided to simply put in every port you could ever need rather than to deny selective ones based on price points. It has a USB port, composite/stereo, component, HDMI, SPDIF, LAN, wireless, everything.
DLNA support means you can stream your own audio/video. From what I understand Roku doesn't do this. Apple does but you have to buy into their closed world to get it. Sony's registration process doesn't ask for intrusive personal info and stool samples, just an email address and the registration number of the box. Updating the firmware is in the menus and is a simple process. It can even be set to tell you when one is available. It supports many video and audio formats which is a plus when streaming your own content and I had no buffering issues with my 6mb DSL connection. Setting up the wireless was no problem. I've heard some claim it supports bluetooth keyboards but I've yet to try it. That could come in handy because using the onscreen text widget is as difficult as trying to send a text message with a 10-key pad. The complaints about the cover art tend to be nitpicks. If you're running it on an older TV it will be hard to see in any case. On an HDTV it looks just fine. I haven't tried any of the premium services yet as I'm not a subscriber but they're there. All in all I'm quite happy for such a small investment.