With very few exceptions, RPG stories aren't that great - they're matched by stories in many other genres these days.
again, why JRPGs are dying. good story at the expense of gameplay doesn't work anymore because other forms have caught up on that front
"RPG" doesn't have to mean "linear as hell with turn based monotony that breaks the flow of exploration and sense of atmosphere" btw