The quietest would be cast iron, because it's thick and dense. My plumber uses this for interior drains where noise might be an issue.
Another option would be to wrap the PVC with some sort of insulation, but this would require opening the wall and using something that would not adversely affect the PVC. I would suggest a self-adhesive tar like material like dynamat but I have no idea if it would affect the PVC. Just filling the stud bay with mineral wool might be enough.
Another solution would be to reconfigure the plumbing so the intersection is a smoother transition; i.e. a sweep wye instead of a tee.