I think people are forgetting that Apple is more than a movie rental box. It's also an iPod for your TV. You can't rent movies in Canada, but I still want an AppleTV. Then I could stream the shows that I record with eyeTV on my Mac, play music, look at photos, etc.
The only thing holding me back is the AppleTV does not have an S-Video output and I'm not planning on buying an HDTV in the near future.