XBMC
LiveTV
The system needs to be running Tvheadend which takes the input from a DVB card and moves it to XBMC Live TV. It's configured through a web interface. In the Howto's there's a section on Ziggo that may apply to UPC as well.
DVB
DVB-C = cable DVB-S or S2 = satellite DVB-T or T2 = terrestrial
A list of linux (and therefore XBMC compatible) hardware is to be found on the LinuxTV wiki
Standard you need a DVB-C card with a CI interface. Some DVB-T boxen also have DVB-C compatibility and a CI card.
The HDHomeRun with TVHeadEnd is your best bet, but unfortunately this is not CI+ certified. So far, nothing is, as CI+ was developed to stop people from watching TV on their PCs.
You can find a list of raspberry pi verified peripherals at here