Theory of many-body effects in valence, core-level and isochromat spectroscopies along the 3d transition metal series of oxides