I generally have it off. I don't need it, I can see it intuitively just from the normal map alone. Past civs have trained me to see the grid without needing it to be explicitly laid out.
However, I have started playing hot seat games with my fiance, to try to get her into Civ. For her sake, since she's new, we leave the grid on.