Not sure where the home is located, I think concrete floors are a great choice for homes in warmer climates, the lime color would be neat.. but may not be attractive to many if thinking about re-selling home anytime in the future.. usually rusty tones or grays tend to be more neutral.

I think that is more about what you like, concrete usually denotes a more modern feel, almost industrial if that is your style do concrete if not find a tile you love and do that.

The DIY concrete floor finishing products are rarely up to "snuff" for a living situation. Most are meant to be put down in a garage where it doesn't matter if it bubbles and lifts in a year or two. Many have failed because of wrong application technique, wrong use, wrong product for the concrete, etc. A finished concrete floor in a new build is a great option. The concrete professionals will get the surface ready for polishing. The concrete floor finisher (may be a different person than the guy who installed the slab) will come in and clean/shot blast the concrete and add a layer of appropriate, high-end, high-density concrete. This concrete is then stained (if you want it) or if you want simply polished and coated with appropriate epoxy. It may take more than 1 application of the stain/epoxy to get the look you are after. This is not a "money" saving product...it is a lifestyle finish that is equal to (in price) other medium/high end finishes. It is very important to understand the quality of concrete seen with a normal slab/subfloor is NOT good enough to be polished and stained. That's why a new coating of high-end stuff is added to the slab. This high-end concrete has all the right properties to receive stain/polish/epoxy.

Hi.. No cement oxide is not the best option though it is an option.. You can look at epoxy flooring.. Similar to cement but give s u a grip in wet conditions.. Try that