Macroscopic energy fluctuations: from normal diffusion to superdiffusion in the evanescent noise limit