This is one of the best articles on Keyword research tool that I have encountered. However, To add more to this, I just wanna point out a tool (LSI Graph) for an outstanding long tail & semantic keyword research. After the recent Google algorithm, Google is now, however focussing more on context & semantics than keyword alone. What do you think about it?
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”

Keyword Researcher is designed to search the Autocomplete databases of Google, YouTube, and even That's a lot of keyword sources! As you probably know, if you're building an authority site, or if you would like to become a dominant player in your niche, then starting with a large database of keywords (that your customers are actually typing in) is a powerful marketing tool.
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.