I use it mainly to see at a glance how far my cities are from going to its next cultural expansion. I know I can see this in the city screen to, but the cultural advisor allows me to see them all quickly. It is most useful, though, in the early game, because in later stages the cultural expansion is not that important anymore (wrt territory expansion, of course).