Like any gimmick, the novelty does wear off a little bit. But since it's a graphical effect as opposed to, say, a control scheme, it doesn't get tiresome IMO. It's neat and complements the experience, like surround sound. You might even miss it a little when it's off.
I've always been a fan of the effect...anything that increases the immersion factor is a plus in my book.