Quick update:
Create note action is now available in custom object workflows
Create note action now includes the ability to “pin” the note.
Thanks to everyone for the feedback about how we could improve the action 
I’ve made sure all other feedback about visibility and priority of notes on CRM records has been passed along to the appropriate teams.