Zapier's UI might be a hot mess but their revenues indicate that the people are will to go with it and use it as is.

All the points you mention, can be fixed by zapier. Then the alternatives do have a moat.