Is there any special kind of DC motor with no mechanical resistance if unpowered?
A wound field DC motor, either series connected (like a universal motor) or shunt connected, will have the least mechanical resistance. Most permanent magnet motors will have some reluctance torque (notch torque) in addition to the bearing friction, commutator friction and aerodynamic drag (windage) found in all DC motors.