It's great to hear that you enjoy making scenarios. The community always needs more talent like yours. I am saddened to hear your frustration with the ANW ScenEditor. However, to be fair, the ANW and HCE games are quite different. AFAIK, the H2/H3/ANW type of game has never had the exact same SE functions as the HC/HCG/HCE line of games. I agree that some of the HCE SE functions like "Probability of inclusion" and "Probability of appearance at an alternate staring point" are very nice features of HCE, but they were never available in any H2/H3/ANW game. There are some ways to work around this problem, but they are work-around solutions and not game features. I am sorry to hear that you discarded the game for this reason.
My experience with HCE and previous versions is that the latest SE for HCE is pretty much identical to the one you might have tried in the original Harpoon Classic released in 1990. The only change for things you can no longer do (that I can remember) has to do with setting Victory Conditions. I think that in the original HC SE, you could be a bit more specific in setting your ViConds to specify units. It seems as though this is no longer possible in HCE. You can still set them, but you might have to be a bit more broad in the selection.
The last I heard, the HCE SE is still not functional in Windows7 64-bit processor. However, the support group says that they are working to fix that ASAP.
I'm very happy to hear that you enjoyed using the PlayersDB.
Welcome (back) aboard, shipmate.