Talking about clean amp sounds, the clean Fender sound has varied over the years. The original '50s tweed amps have a much more mid-forward sound than the later '60s blackface amps. Don't forget that the first Marshall amps were based on a tweed Fender Bassman circuit, with almost no change in the circuit. And the difference between a tweed and a blackface sound may only be 3dB in the mids, not a -12dB change from turning your mid control right down.
A clean guitar sound will always cut through a mix better than a distorted sound at the same volume. Distortion adds lots of extra harmonic content to the basic sound of a guitar, which pushes a lot of the energy in the sound into the higher frequency range, so for an equal energy sound level, the distorted sound is spread over a much wider frequency range, (even though the guitar speaker itself filters off a lot of the high-end sound), so theer is less energy in the mid-frequencies.
Also, look at the Fletcher-Munson/ISO 226 curves for human hearing responses (it also varies depending on the loudness of the sound):
The human ear is most sensitive to sounds in the mid-range, and far less so to bass and treble frequencies. So if you scoop the mids, then you are reducing the frequencies that the ear hears best, so the overall volume has to come way up to compensate, which means the bass and treble are then far too loud.
These two videos best describe how not to get a good metal sound live (second one on next post as you can only include one video per post).
You'll probably find that the guitars on metal albums are EQd differently depending on how exposed they are in the mix. A guitar-only intro riff may well be quite scooped, whilst within a full-band context, the settings on both the amp and the mixing desk will be quite different.