runamuk's post in Windows 11 VM - Possible to have Vdisk to show as SSD ? was marked as the answer
I tested this for SCSI and SATA and it worked. I was able to get it working by just changing to the appropriate device\volume name.
</devices> <qemu:commandline> <qemu:arg value='-set'/> <qemu:arg value='device.scsi0-0-0-2.rotation_rate=1'/> </qemu:commandline> </domain>