Welcome email not sent when adding user from console

I guess you can use Invites feature for this functionality. Invited user can choose their password (optional) while accepting the invitation.