I haven’t used ANSYS Motion, I have used MBS software which used the Recurdyn solver.

NVH = Noise, Vibration, Handling.  ANSYS Motion would be preferred for the Handling portion of NVH.  ANSYS Mechanical would be preferred for Noise and Vibration.  Specifically for the Noise portion, you can use a Harmonic Acoustics analysis. For Vibration, you can use Transient Structural, but the computation times are long and the storage requirements large.  You can get answers to many Vibration questions with an order of magnitude less computation using a combination of Modal and Harmonic Response, Random Vibration, or Response Spectrum analyses.