You have lots of options to create a textured wall. Microcement is just one ... As with paint, you can get a matte, satin, or glossy finish depending on the type of microcement you use.
Not all paints are created equal; some finishes can make your wall sing, while others might leave them looking a little flat.