Cough cough Mass Effect cough cough Cyberpunk 2077 cough cough

I personally find the most important part of those choices isn't the actual effect, but whether the game managed to immerse me enough so that I care.

For example, in Life is Strange, there's a string of choices you can make that will get someone killed (or save them). The game invests enough time in the character before hand so when you come to the crossroads, the decisions FEEL very important. Do those choices have any big effects on the game? Not really. The character isn't part of the main story line anymore after that, you only get some people referencing the difference. But if FELT important.

Think about the polar opposite: Choices that change the entire game, but you aren't invested in. Would those be interesting choices, or would that just be 2 games in the form of one, and the choice is just a kind of "game select screen".