Advancing nano-optical investigations: Metallic and dielectric Mie particles in SPM techniques and their emerging applications