The basic idea – Mythos-infused tobacco causing destructively-seductive ghostly apparations and visions – is pretty good all on its own. But you could also tie it in with the black lotus and whatnot found in the Conan novels, and thus bring in the Hyborian Age stuff that Trail of Cthulhu, I think, would find rather entertainingly useful. I mean, there’s some of it in there now, obviously, because Lovecraft and Howard were friends and pen-pals. But you could really ratchet up the Howard for a Pulp game.
Something to think about, I guess.