Sigh. What you describe is an issue that I have experienced too. I work in Business Intelligence and only discovered Apache Hop by accident. I think the issue is lack of SEO pushes some great products down the search results list. I actually now search Reddit or HN for software suggestions for a particular area. Just using Google will give you the list of best marketed solutions.