You can do a lot to concrete to make it look special. It is important to have an experienced installer, so what you start with is level and has the finish you want: smooth, brushed, stamped, etc. When doing a new patio color can be added to the surface after it is finished but still damp. But even old concrete can be fixed up using stain and scoring. Below is a photo that shows plain concrete that has had lines cut into it. You could have concrete stained, then have it scored. This can make the sections look like colored stone as shown in the bottom photo. The colors used are dark, but light colors are available and are usually layered with other colors. If you go for staining, ask to see photos of completed jobs so you can indicate the look you want. The concrete has to be sealed after staining. Choose a low sheen sealer for a natural look.