Cablecard tuners don't tune analog or OTA/ATSC, the chip they use is qam only so throw all those out of consideration for satellite (unless you really want to spend a lot of money and convert the component output to clear qam, but you would still need a tuner).
You didn't mention which receiver which might make a difference on controlling tuning as well as outputs available (such as having a TV2, component, composite, hdmi, etc .). If you were really only wanting the coax out of the receiver, nearly any analog tuner would do (including the 2250 you mentioned) but even then I would probably use an svid or composite output if available (also depends on tuner having A/V inputs). I'm also not sure why you are looking at 2 tuner cards in this scenario (I can think of a couple of reasons but from your post I don't think it will work the way you are thinking).
Generally speaking, if you want to build a dvr for satellite, the Colossus or the external HD-PVR are what you should consider. If for some reason your receiver is not HD the colossus might be overkill but the price difference isn't much for other hauppauge cards. I might consider that 2250 but there are many others that would be better/cheaper depending on if you also want to tune analog cable and/or ota at the same time.