Welcome to TNet, Craig.
Back in the day, there were no pinpointers, then they started hitting the market a few years ago, and now they are an indispensable tool. They are particularly useful for land hunting, when you are doing plugs and trying to keep your holes small. That's about the only time I use mine. I don't use it when water hunting - I just dont think its necessary. I also dont use one in turned-over fields. Its faster and easier to wave handfuls of soil over the coil.
That said, you can't go wrong with a Garrett Pro-Pointer. Its the most talked-about, and most common pinpointer out there. It is rugged and durable, and there have been a lot of mods and customizations for it.