Hi Julian,
don't forget we are a browser based tool - 95% of all those ETL tools are native clients/applications. Even brackets is not designed to fully function in a browser (though there has been some work to make it do so - it is not part of the main branch). Trying to call out to a non-browser tool for editing functions is fraught with possibilities for errors etc, which we would rather avoid. Would the editor be local ? on the server (also served up ?) - opens up too many dependencies and installation fun and games that we don't want to get into right now.
The Orion embedded editor we use could be enhanced - but again it is in the browser so we need to be mindful of size before going too full-on.
There may well be a better compromise and we're happy to hear all the ideas.
You mention the mongodb node - I thought that either save or update should allow modification of existing data - in both cases you would need to supply the existing document _id or a new one gets allocated.
You also mention other nodes not being flexible enough... happy to hear your thoughts on those - or even bullet points for discussion, and likewise any suggestions for missing nodes - we're not looking for an extensive audit/list - just some clues for big holes to start with :-)
Ramble on !