Dare,
I feel your frustration.
There's plenty of people on the forums telling you to try this tool & that tool (including me).
But there's nothing here about the mental process that needs to take place to generate those ideas.
I've written a blog post '
That Magic Feeling When You Find a Niche Market' for you and others who feel the same way.
I hope it helps.
-Mike