I've run House of Dust and Ash with a Rogue Trader group and have heard of other people's experiences in Dark Heresy but has anyone tried the Haarlock Trilogy in Deathwatch?
I imagine it would have to be modified considerably to make it challenging for space marines (unless their conspicuousness would itself be enough of a penalty). Less social infiltration and more either sneaking around or straight forward assault. Bypass the defenses of the House of Dust and Ash or just drop pod onto the island, that sort of thing.
Of course, there is the idea of running it straight out of the book to much hilarity as the killteam lives up to its title...