I'm not so sure that it has anything to do with complexity of understanding. Joins make scaling RDMSs horizontally much more difficult, if not impossible in certain situations.