Has anyone successfully integrated Netsuite with ActiveCampaign so that ActiveCampaign automations trigger based off of the project stage being changed?

Their API seems pretty good, I'd start by testing via Postman first to check the updates via the API trigger the automations you mention. This is the API URL which tells you everything that can be achieved via the API ... https://developers.activecampaign.com/reference#overview