They just seem too many to begin with. I'm like "What of they confuse potential users rather than help them integrate into the steem ecosystem faster.

Confuse about what? That it is an ecosystem of a plethora of apps using the same blockchain instead of a website? That's decentralization. That is the entire premise of it. Development taking place in a multitude of directions without any centralized guidance. Steem is a public blockchain. Anyone can develop an app that uses it. Anyone can use it.

If you don't like some front ends, just ignore them and use those that you like. Look at the bright side. Suppose you become enamored with some app and earn a lot of rewards on it. Your account grows. But then the popularity of that app wanes and your opportunities to keep succeeding trickle down to near zero. Thanks to your account being on the Steem blockchain, your earnings will not disappear. You can continue doing something else! In the world of centralized and siloed apps, all your earnings could be gone if the app that you earned them on goes bust.

Also there's the fact that very many will most likely fail

Fail how? Not gain long-term popularity? How is that a problem?