Yeah, that is exactly right.
If you want to use S-Video to turn your TV into a monitor for applications you will be disappointed. However, watching video has been fine for me with my Radeon 9800 running Windows XP Media Center Edition 2005 on my HTPC.
If you really want to get it right...