I used to play this game years ago, and I remember there being quite a number of really top notch user made campaigns, but most of the sites now seem to be out of action. Does anyone know where I can get old campaigns?

Try heroescommunity or celestial heavens.