This sounds like a well thought out list of features. Potentially one way of tackling this awesome feature set would be progressive deployment. Categorize them in priority or dependency-wise. Visual Studio is in no-way a light IDE. So, starting an in...
In my fiddling around I noticed that even updating the database record to have a `targetresource` count is not sufficient in triggering the processing of the active queue items. It seems to only be triggered on the UI control.
Not to point out the error in this official response but.....the link is to this exact idea.Therefore, I would recommend removing the "Duplicate" status.