Hi – I’ve read your post with great interest. Not only am I happy for you and your success, it does provide a glimmer of hope to those of us who do have “other” ideas. I, too, have had an idea for a very long time now, but I have no idea how to go about “making it a reality.” I am not a programmer either… though I do know some html… I also remember the old days of having even a web developer holding domains hostage, never mind the site’s entire code. And, yes, that is one of the major things that stops me from even discussing things with a developer. I simply don’t trust them…
1) SEMrush - I believe that among all the 3rd party software, SEMrush has the largest keyword database. Their search volume data is pretty accurate and aligns with the Google keyword planner. Also, based on the type of content that needs to be produced (i.e. informational, transactional, etc.), one can utilize different filtering options available in it.
Google prefers to not share long tail searches in this tool – because the tool is designed for Google Adwords advertisers. If advertisers bid on those long tails – they would have less competition and therefore pay less for the Adword, and therefore Google would make less money e.g. bidding on the term weight loss for girls under 18 is cheaper than weight loss.
The limit on manual keywords could be higher. I personally wish we could input 10,000 keywords at a time, instead of 200. However, I understand the costs that Long Tail Pro has to maintain each time a new manual keyword is input. Not a deal breaker, I just wish the limit was higher. (To be fair, I don't think most keyword tools have a bulk manual option at all).