Just amazed by the response to this post!!! As a note, you can have bambie buckets as a cargo from one of the mods, and adjust the weight. The most recent update also has a trigger to stop a "fire effect". So in regards to making a mission with helo's and buckets, triggered actions could start some spot fires, then require the hover parameters to be met, cancel the smoke and fire effect. Then trigger a white smoke effect (Steam). The first page of this post shows an SAR server, they have a neat script.
Even without a 3rd party MOD for a CL-415, or special effects for the Helo's water buckets, I think there is an ability to make some cool scenarios.
I have some ability with the mission editor and it's triggers, but not with scripting. There should be enough talent out there to get a MOD together, that brings these existing options together.
If I win the lottery, I will pay a 3rd party to make the CL-415 DCS quality. Final note: To all those quoting "Combat Sim", somebody has to put out the fires that War causes.