I use mine mostly for Youtube. Or rather, my son does. He loves to be able to browse Youtube on any of his moms iPad, his Android tablet, any of our laptops, any of our phones, with the convenience of a proper input device, yet get the video onto the TV.
I've just gotten an Amazon Fire TV (not the stick) and while you can get Youtube apps for it, I'm not sure I'll be bothered for this reason - a tablet or my phone is a superior interface for deciding what to watch. And frankly, I'm more likely to know where either is than where my TV remote is, while it'd be hard to turn around without seeing a couple of devices that can control the Chromecast in my house...
I also use it for Rdio, and (very occasionally) I cast a Chrome tab.
I have no interest in the smart TV's because of the lifetime of TVs: I've owned the TV's I've had for 5-10 years each. In that kind of timeframe, how I've wanted to use the TV has changed drastically each time.
I prefer my TV to be dumb in most ways, and instead replace the devices I use to control. The only functionality I wish for from my TV would be the ability for input sources to request volume changes, change input source, or turn the TV to/from standby.