Personally, I both like and dislike the snorkel, in the same way I like and dislike a cap, or an aftermarket bumper, etc. I think as others have called out, 90% of people that install a snorkel don't actually need it. There are a lot, a lot, of mall crawlers that rarely see dirt but love the extreme off road look. There are also a lot of guys who like to dress up like ex-special force guys, these guys often overlap too!
All that said, who really cares. I think it's pretty cheap insurance, even if you're not crossing water often, a single water crossing gone wrong will cost you orders of magnitude more money in an engine replacement than that snorkel cost. So, "cheap-ish" insurance, all things considered. The cheaper option is just stay outside of deep water, or you know, walk it first (which you really should be doing regardless).
I think they look cool, I may get one if I keep the truck, but it's way down the list as I've not been anywhere near close enough to need it and I'll just stay away from water crossings for the time being.