All moissanite will have some subtle color. Relative to the diamond color grading scale, the best material will compare with the J-K range.

I've heard of sellers making a comparison with H-I color or better and I believe that is exaggerated. I work with moissanite on a fairly large scale and have done so for over 10 years. While the relative size and shape will have an effect on the visible tint, usually I am able to hand select the best material for my clients and they are generally well pleased. A lot of it has to do with how realistic their expectations are and that's why I'd rather be accurate in my representations of what color to expect.

In some instances, they might actually be happier with the colorlessness of Cubic Zirconia for $5-$10, whereas most of my clients are willing to pay for the more expensive moissanite, because of the many other properties that are more diamond-like.

It is much harder than CZ, being the hardest gemstone second to diamond. It takes a polish that is rated even higher than diamond, which gives a very crisp brilliance - comparable to diamond. When hand selected, it is usually possible to make available material that will set well in yellow gold, white gold and platinum, but not always in some of the fancy shapes.

Moissanite can be easily separated from diamond if magnification is used in the examination by a trained jeweler. Because it displays double refraction, which diamond does not, moissanite should not be confusing to a trained jeweler, especially a gemologist. However the thermal probe that was used as a shortcut (yes/no) tester for casual separations, prior to the advent of moissanite, was not calibrated to the degree necessary to test accurately for moissanite and some (lazy or untrained) testers without examining the stones under 10 x magnification would get a false positive result for the moissanite as diamond.

If it were not for the double refraction, which is somewhat easy to see under magnification (but not with the eye), it would be much more difficult to tell moissanite from diamond. So the answer is that their physical and optical properties are very similar, making Moissanite the most effective alternative to diamond, in my opinion.

I believe that the most "diamond-like" appearance is achieved with the Round Brilliant and the Antique (Square Cushion) Cuts, as both show the best and most even brilliance. The material is very stable, as far as I know, and has never been suspected of discoloring over time. It hasn't been around long enough, however,  for any definitive extended long term study to have been performed.
If you would like, please feel free to call me and we can discuss the specifics of your interests in more detail.