The San Francisco Mission District is so awesome with all of it's brightly colored murals. I was there recently visiting a friend who lives right in the heart of the mission 1 block from this awesome ceramic mural:
This mural is on a wall of a small kids park that includes an ornatelymosaickeddragon kids can climb on. It's tropical and made mostly of handmade ceramic tile. Beautiful!