For computer rpgs (including jrpgs and western rpgs) this is a total non-factor. There are plenty of RPGs with little to no C&C.
Choice and consequence is the essence of the Role-Playing Game. Otherwise a gamer should just stick to XCOM and other Tactical games.
How is bankrupting your organization, losing supporters or assets not a consequence? Actually, XCOM has more C&C than most RPG. Also, you need to play Kenshi. You probably won't be able to get better art anyway for such a niche genre and no budget.
The problem with denigrating "idea guys" is that the "idea guys" actually do a lot of work. There really should be a new name for people who just suggest grandiose ideas without going into any specific details or fleshing them out properly.
People who make GDDs are called "game designers", not "idea guys".
Level designers typically do the level design, the writing, sometimes some of the PR. I started my game with a design documents because I had read it was a good thing to do. It was a total waste of time, and I think there are zero lines that are relevant now, except the pitch.
Actually, applying for level design at a company you want to work with is probably the "regular point of entry" in the industry.
Designing a board game is not just writing cool ideas on a sheet of paper actually. It is mostly seing the results of what you have written be played, try to understand why it doesn't work as well as expected, despite everyone getting out of their way to tell you they had a great time because they are afraid to hurt your feelings.
This part is exactly the same in video game design actually.
Another possibility is to start by modding an existing game (or just using whatever level design toolset exists for a game). The main problem with idea persons is that everyone has its dream game, so unless you happen to find someone who has the exaxt same dream game, it won't work:
I have worked with quite many freelancers over time. They basically work for money, so that they can have enough savings to work on their own free game.
Only people who already worked with you before may give it a shot.
That is another reason why modding is a good place to start with: modders are used not to get paid, or to apply as level designer somewhere (so that you can talk your colleagues into leaving the company and starting one with you).
The last option would be to take part in game jams: it is a great place to find people you could work with, and see whether it matches.
