The Leo sign-up is a nice option to have. We need some good tutorials that people can easily find to help them get started. Not everyone has a mentor.
From what people are saying it seems to get a lot of sign-ups who give up quickly. Retaining users is important.
Very good point about retaining users, maybe we can make a newcomers community, it can be for new people and those who want to help new people. To make newcomers feel more welcome and help them learn how to use Hive because at first, it can be a little overwhelming. Established accounts on here that have some hp to throw around should help boost new users, I believe that nothing will retain users like seeing rewards or seeing that their post is doing well. Often newcomers sign up and they struggle to get traction and this could be the cause of losing people after they sign up. If a community for new users is built I think people will make the effort to make sure that new accounts succeed.
People should be looking out for newbies anyway. Those early weeks here can be vital and they need help.
I joined Hive back when it was named that other coin and I recently wrote a post about why I chose to post my content on Hive and why others should as well https://peakd.com/hive/@wedacoalition/why-content-creators-should-use-the-hive-blockchain
I understand what you are saying that users should be aware of new users but imagine if we had a community dedicated to this, where Hive OGs could see all the new users in one place wouldn't it be easier?