Things to compare between memory are voltage ratings, timings, and speed. The performance between the slowest DDR3 kits and fastest DDR3 kits doesn't justify the cost in nearly all cases.
In general, both the XMS3 and Vengeance kits serve the same mainstream market. Low profile just means that the heatsinks are not tall, in case you are using a huge CPU cooler like the Noctua NH-D14. The Dominator kits are the highest speed, enthusiast grade memory Corsair makes, although by far the most expensive.