Your problem sounds similar to mine.
ASRock Z77 Extreme4-M: TV Tuner not working after sleep, doesn't work until cold boot (off for at least 10 seconds)
what happens if you pull the power for 15 seconds after a shutdown? Will it detect then?
It seems there is some sort of weird compatibility issue with these boards and this card.