Epoxy coating is what I have in my kitchen. It is a 2-part that I had to order, as the ones I saw at the home repair stores were single part. The 2-part is durable and reasonably simple to install, if you have the time and drive. If you are not doing the installation, then I would insist on a professional installer. The floor prep, cleaning and then installation all have to be done quite well for the system to work as it’s supposed to. I do have a couple spots where the epoxy has flaked, but it isn’t in a tragic location, or large (size of a dime or less). Epoxy will chip if struck in a thin spot with a sharp, heavy edged something. The concrete subfloor must be very good, as any chipping or degredation of the concrete itself will undermine the flooring.
Both VCT and epoxy can get slick when wet . . . even with the traction grit the epoxy kit supplies. Be aware of that codistion and what your plan is to deal with it. The slip resist shoes work very well for us; non-slip mats also work great. Epoxy is a BREEZE to sweep and mop. The grit eats the brooms a littlequicker, but not so awful.
My favorite floor to work on has been the terra cotta tiles. Do ask about a grout that isn’t concrete based: it holds onto food, degrades over time with water, and can wear uneven if not installed well. Once you get grease into that concrete grout, it is HECK to get back out.