Soft finishes, trompe l'oeil, and stenciling can be used  to enhance a room when an artistic statement is needed.  See samples below.