I don't have a preference, really.
I do like seeing the smoke, and watching as the pipe turns colors after a few sessions, but it's not nessescary for me.
There are some really nice ones that aren't transparent.
It just depends on the individual piece.