I'd like to create frontend member profiles. My confusion is do we create a post type for each profile or is there any guide of documentation of guidance for this process?
As you shared the idea, you should create a custom post type "Member Profiles" that will allow you more flexibility like if you want to create post relationship, you can create using post type "Member Profiles" but you cant create post relationship using users (authors).