I have and do use adgooroo link insight - both paid for and as a beta tester pre "Qbot2".
I have found it useful - and sourced links I think I would have been unlikely to find as a result, so certainly brownie points for them there. Depending on your sector or niche - you can end up running out of new link targets quite quickly - which then calls for some "outside the box" thinking and switching your competitor urls to a broader sector, and changing keywords in the same fashion.
Its certainly not a 5 minute tool by any stretch of the imagination, it will will work better for some niches than others. (I found some areas very "noisy" because sites had simply press-released their way to the top as it were)
The tool does have the odd hiccup with a few false positives - but then in fairness I have yet to see a tool in this field that is 100% - the support from them as a whole is good too.
Price wise - I personally think it is a little on the high side - and you do really need to leave it to run for the first 2-3 weeks just to gather enough data (although again this will be dependant on sector), if you are in a highly competitive market then there is value to be gained from it provided you can commit the time to using it.