Magnetic nanorods driven by rotating fields in water can be rapidly steered along any direction while generating strong and localized hydrodynamic flow fields. Here we show that, when raising the frequency of the rotating field, these nanopropellers undergo a dynamic transition from a rolling to a kayak-like motion due to the increase in viscous drag and acquire a finite inclination angle with respect to the plane perpendicular to the bottom surface. We explain these experimental observations with a theoretical model which considers the nanorod as a pair of ferromagnetic particles hydrodynamically interacting with a close stationary surface. Further, we quantify how efficiently microscopic cargoes can be trapped or expelled from the moving nanorod and use numerical simulations to unveil the generated hydrodynamic flow field. These propulsion regimes can be implemented in microfluidic devices to perform precise operations based on the selective sorting of microscopic cargoes.