According to documentation, archetypes "occur in addition to any scripted effects that may result from the Papyrus Script on the MagicEffect."

But in my experimentation, it seems that applying an archetype to a magic effect totally negates anything in an attached script.

Can someone help explain this?

What are you trying to set up? There are a ton of magic effects which also have scripts attached to them and work fine.