For consoles through a PC, I cannot recommend enough DScaler (freeware)- I would even go so far as to choose the TV card / Video input card based on whether or not DScaler supports it.
I cannot speak for Digital TV cards though, but I'd imagine they must have some sort of S-video or Composite (eurgh!) input.