Realism is SHIT most of times. Imagine your character crafting, building something, then he must stop for urinate or poo. Very, very funny (sarcasm). Or even better (worse), you must make a check or get depression, fail the check and you cannot do anything.
Realism is great a lot of times, is why there are so many survival modes for different games. Bodily functions are already in another game I play, SCUM. This is not a pain at all, you just have to remember to go like in rl before you do something important. Mental states may very well be added before release, there will soon be a better metabolism and injury system than the current one.
I can think of a far more popular game series featuring it called The Sims
This can work on Sims, since the game's own premise requires it. If you are going to put realism in fantasy, forget about huge flying dragons, since flying animals bigger than a Pterodactyl go against the laws of biophysics. What I said can be considered moderate realism, in the extreme of realism you can't even have dragons.
But yes, if you want a good survival, then realism is desirable, but even in this case I cannot think of even one game that I can say it´s soo realist that I can learn real life saving skills from the game in all details. If there is one, then please tell us because I look for a long time.