I’ve noticed some units do not play the right production sound. This list is not exhaustive, but here are what I found:
Regular unit with a native unit production sound:
Landwehr
Native unit with a regular unit production sound:
Sudanese dervish
Conquistador