There seem to be two types of SIG sights. I believe one is for the P229, and the other type is for all the rest of the SIGs. The second type is what will fit the XD.
I just put an LPA black adjustable rear and a Hi-viz front on my XD Tactical, and I think it's a big improvement. The LPA sight required the elevation screw to be shortened somewhat, since it was bottoming out on the slide. Also it overhangs the rear of the slide by about 1/4", but I don't mind this because it increases the sight radius, and this is a competition gun anyway.
The Hi-viz sight looks cheesy, but it has held up through three matches so far (IDPA and the SA Action Pistol Challenge). That huge dot really jumps out at you, and much easier to pick up than the Dawson Precision fiber optic. Plus, it's a very simple matter to swap out light pipes.