Sort of a personal review:
I don't own a Slingbox. I bought a HAVA Titanium HD at Woot in June 2009 for $65 shipped. It is my favorite Woot, and I use it all the time.
Since the HAVA more or less does what the Slingbox does, a lot of my experience is relevant.
As other posters have written, I use this mostly for sports. I can watch games on my laptop, netbook, or iPod touch ($10 HAVA app) while I'm out of the house. I can do this anywhere there is wifi, and here on Long Island that includes many commercial venues and almost all public ballfields where my sons play.
Sometimes I do watch non-sports events on my laptop in my bedroom, where I don't have a TV. Note that with the HAVA, that's 720p, which the Slingbox doesn't do (max 640x480 through the network). Over the internet, Hava does 480p (DVD resolution, which ain't bad), while the SOLO does 240p.
Since the SOLO streams in lower resolution than the HAVA, the picture may be smoother, but I haven't had a problem, as long as there's a reasonably strong wifi signal.
The HAVA was a lot cheaper, but it didn't come with the network bridge. But as long as you have wifi in your house, who cares? You get better resolution anyhow.
BTW, I'm sure a lot of you are wondering how you control your tuner remotely. Both the SOLO and the HAVA have IR emitters that you place on your tuner. They're fairly unobtrusive. Then you select your tuner model in the software, and you see an interface that looks like your remote. I can change channels, view the online channel guide, adjust volume, record to DVR, use picture-in-picture - in short do most anything I can do at home. I can even connect a USB hard drive or flash drive to the HAVA and record to it.
I don't know if Slingbox has fixed their capacitor problems. But even if they have, I think the HAVA is a better value. To be fair, I know a couple of Slingbox owners who swear by them.