Anyone have any experience and opinion on pros and cons of various options? Looking to ditch the cable. I've looked at various reviews, but wanted to hear from people I "know" :-)

I have a Roku. I like it for what it is. But it is not the panacea that many make it out to be. As with most of these there are limitations. Most of them require "apps" that you subscribe to via the device. Some apps are a pay subscription like Netflix. Also your provider of internet services may have limits so your service may be throttled (cut back to a slower mode) or have extra charges attached if you go over your limit. All in all the experience has been a good one and the picture quality is excellent. They even have an app to steam from your phone directly to the device which in turn can be displayed onto your tv.

Research is your best friend. Some apps only allow some providers access so you can stream their programing. Look carefully and see what it out there for your area and provider. Apps like Syfy have the content but it is provider specific. So check on registration before you buy to ensure you get a great experience.

I have a Chromecast. It is just what it is - a small USB that fits into a USB slot on the TV and is used wirelessly from your computer. It doesn't come with anything. It can cast what is on your computer, or what you select from a service you subscribe to like Netflix. An HDMI cable does the same thing.

I had problems for almost a year that I blamed on Comcast, but they were in the Chromecast, which I had plugged into the computer at both ends the way I was told. Turns out that screwed up tv reception. Had to be plugged into a power strip that had a USB port.

I have minimal cable but keep it because I'm lazy and often snooze in front of the tv with the remote, rather than having to go to my computer.
Certainly more and more tv channels are now on the net, some of them in real time.