It's like media centre for windows. If you got the apple remote that came with your mac, then you'll find it more useful as you can control it from a distance, say from your bed.
Ok so the only real benefit of front row is to watch videos and use the remote?
Can you record stuff from front row or any other features that it has? You say its like windows media center how do you stream from it?
At least FR doesn't leave iTunes running in the background anymore.
That was the BEST thing about FR in Tiger. Integration with itunes was fantastic. I used FR for music all the time back then, when you could switch between the desktop and FR without the music stoping. I don't see how that could ever have been a problem.