It takes a certain kind of a skill set and experience to be able to translate this "consumer view" into something that can be acted upon by a developer.

Sure, the skill set can be developed, the knowledge (about software development, the available technologies, and having an idea of what is and isn't feasible in the first place) can be built up, and the experience (communicating with developers) can be accrued, but that really stops a lot of people from even thinking of contributing.

Perhaps a subset of the (open-source) community can help in developing these (skills, knowledge, experience) among interested people. Teach people how to look for issues, bugs, or come up with feature requests; teach them how to put these into a form that's easily understood and appreciated by the developers, and finally, teach them how to communicate with developers without losing the "non-techie user POV" which makes their feedback valuable in the first place.

IDK though, having read what I've just written, it seems to be quite a task.

Because FOSS devs think the "consumer view" is wrong and the software should correct it, not the other way around.

I have a background in Games, UX, Service and Product design and I would really like to contribute to FOSS projects but have no idea how to

I’m unfamiliar in the etiquette of GitHub and how I could contribute my skills

because a lot of foss devs, contributers and even users are so extremely hostile when suggesting ux improvement/report bugs/etcetc for end users not like them that frankly I dont wanna bother. Same reason I don't report bugs

maybe first tackle that situation before you ask people to throw themselves into what effectively is a lion's den to mauled by fossbros who can't get over themselves