>"Is there any money to be made in CPAP hookahs?"
Maybe they can be converted into hookahs. But I don't think that would be profitable because medical devices usually cost more than other stuff.
However, if the substance being smoked causes disease, you could find a lot investment money to support that business.
Disease-promotion is the number one business in the US.