I work in residential and commercial construction.. I have seen plenty of concrete basements that were well over 30 years old get ground down, dyed and either sealed or epoxied. Yes, it is possible and yes, if done right looks great. There are a ton of companies that do this, get references and ask if you can see some of their work that they have already done in the field.