I use Ahrefs to find ideas for keywords to add into content, and content to create around keyword opportunities. I like how Ahrefs shows keyword difficulty, search volume, traffic potential (how much organic search traffic it’s possible to get when you rank #1 for a parent topic keyword) and lets you group keywords together to create lists. It’s really useful.
This database was built using data from BEFORE Google required active ad accounts to get good keyword data & before they started blending data together for similar terms. Even if you set up an AdWords account and spend significant sums of money with them, they may require you to run your ad campaign for 3 or 4 months straight before they will show reasonably precise data instead of exceptionally broad data ranges.
Long tail keywords can find people who are later in the buying cycle, and more ready to buy. For example, somebody searching for “tents” is probably early in the buying cycle, just starting to research what they want. Whereas somebody who searches for “North Face Kaiju 4 person tent” already knows what they want, and is more likely to be ready to buy.