What I really like about them is extensive detail including the keyword difficulty. Ahrefs uses clickstream data to also show how many clicks you will get from the search engine. This is very useful after knowledge graph integration, as many keywords may have huge traffic but they hardly get any clicks from the search engine. Reason being, they get answers directly from the Google search result. Example of one such query is: “birthdate of any celebrity”
"I rarely get excited about SEO and SEM tools...But, when it comes to keyword research it is virtually impossible to produce a quality worksheet without software. When I have to perform the same task for my customers, the process is even more daunting and time consuming...there is now a better way to manage huge keyword lists and this tool is called WordStream."
Long Tail Pro is a keyword research tool that helps you quickly find low competition keywords for your website.  In particular, the tool is built for people doing SEO (search engine optimization) as opposed to people doing paid ads (Google Adwords PPC).  I'm sure there are some advertisers that use the tool for paid ad keyword research, but the tool was built for SEO keyword research.