It depends on the app. I never looked to see what WinTV2k used, but Dscaler seems to use about 25MB, regardless of the card.
Now, if you're referring to CPU time, for just watching, again, it depends on the app. With the .vxd drivers, on Win9x, using WinTV2k, almost no CPU time. Switching to...