I have a new found love. Boxee.tv is exactly what I've been looking for over the past year and a half.
I don't have cable TV at home, but just have a Mac Mini plugged into my 42 inch LCD TV. It's great for everything, and I watch all of my favorite shows online and also use the Netflix "Watch it Now" service a bunch too.
Boxee is a stand alone app that consolidates all of those things and more into one Front Rox like interface. You just use the Apple Remote in Boxee and you can browse TV and movies.
Additionally Boxee will access all of your media stored on your computer. Now all audio and video files are at my fingertips without leaving the couch!