You're correct on the latter point; the Media Center functionality (not to be confused with Media Player) was used by very few.

That said, if you have cable TV in the US, it was the best way to use your own hardware to watch cable TV.