On the hierarchy of electronic and magnetic energy scales in novel 3d, 4d and 5d transition metal oxides probed by X-ray techniques