Cre8asite Forums has an excellent new thread named Keyword Research and Related Tools, What do you use? The thread contains many ideas for tools and common sense ideas. Here are some tools:
Ammon Johns goes about it a different way. He takes out the old clipboard and pen and talks to people, actual people.
Forum discussion at Cre8asite Forums.