Noise in NbTiN, Al, and Ta Superconducting Resonators on Silicon and Sapphire Substrates