SEMrush is a very useful tool for both researching competitors when starting a site or for growing an established site. I really like to find weaker niche sites that still seem to be ranking for lots of keywords; SEMrush helps me see what they are ranking for and what I can potentially target. You can also see what keywords you’re on the cusp of ranking for with your established site - another very useful feature.
Long Tail Pro is a keyword research tool that helps you quickly find low competition keywords for your website. In particular, the tool is built for people doing SEO (search engine optimization) as opposed to people doing paid ads (Google Adwords PPC). I'm sure there are some advertisers that use the tool for paid ad keyword research, but the tool was built for SEO keyword research.