I think the reality is its a fantastic tool to have in your kit bag, but you have to be prepared to work hard sometimes to use it to good effect, and ideally you want to be starting with plenty of high quality low noise, oversampled data.
Settings for faint wispy detail can sometimes be different to the stars, so might also need to selectively mask before applying too is another variable.
If you even get it all figured out can you give us all lessons Steve!