You can try DeepMiner. It is good for scrapping, rank position, generating long tails and keyword suggestions. You can export the data to document for later analytics. You can find popular keywords that people are searching for. 7 major engines are supported, Google, Yahoo, AOL, Amazon, YouTube, Ask, Bing. It supports multi-threading so it is very very fast scrapper. BTW you must use proxy list if you plan to scrap thousands and thousands of keywords.
In fact, Google Suggest is the best way to find good long tail keywords that people use to find information on Google. Google admits that while Google Autocomplete (another name for the Google Suggest feature) was not designed specifically for marketing, it can deliver meaningful insights and help stay on top of trends. There are also many clever ways to use Google Autocomplete that can help you with SEO.
Scout is an easy to use extension tool for chrome browsers that turns your website into a significant keyword generator. By a click of mouse, you can uncover relevant keywords in your industry by choosing a website that is successful and attractive to your audience. You will be able to understand the true language of your successful audience and generate keyword ideas that you can use in your marketing strategy.