one of the biggest gut wrenching choices in my opinion is Radiata Stories where halfway through the game you have to chose between siding with the humans or the non-humans. where friends become enemies and every strategy (because of the 170+ party members being halved)is changed. i never got to play both sides but in the one play through of the game I enjoyed it.