Explorations of Spin Excitations and Dynamics in Homonuclear and Heteronuclear Spin-1 Atomic Gases