i’m gonna blatantly disregard your “but where the consequences actually matter” and recommend most of telltale’s games (The Walking Dead and The Wolf Among Us are the better ones).

besides them and the suggestion of others i would also recommend Tyranny. great CRPG made by Obsidian.