I just hope that the stupid things that tend to happen because of the current incomplete/placeholder systems will still be possible, just no longer all-but-default, in whatever complete system goes in eventually. My main reason for this is that a lot of these weird things -- being pulled out of depression over a spouse's death by a lovely view of a waterfall -- can and do happen in real life, just less frequently and, well, with all the other pyschological factors involved being just right too. Of course, in real life you could also go the reverse way: you supress your anger and sadness at your wife's death until the next time you see a pretty thing, at which point you're reminded of her, the reminder gets past your mental filters against direct thoughts of her deadness, and you break down sobbing. And from there you can go into the depression phase or skip to the now that I'm not surpressing it I can deal and eventually get over it. All sorts of ways a more detailed psychology can go, many of them just as wacky on the whole as the current limited dwarven psychology. So in the end it's not so much that it currently lacks realism as that it currently lacks detail; with any luck the detailed version will be just as crazy because, well, real life is.
(Feel free to count how many times I repeated myself in that paragraph. This is not one of those nights when I am going to spend more time editting than writing. My NaNoWriMo friends would be proud, but I'm still waiting for the next generation of the WriPhone instead.)