Not sure what you'd like to use it for but if you're a recreational diver (as opposed to bottom scrubbing etc) it's worth looking at The Air Line. I've had their larger unit for a few years and have done hundreds of dives (down to 20m with a buddy no problem).
The downside of my Hookah is that it's noisy - like a lawnmower mowing the tranquil cove. I can (just) hear it underwater and I prefer knowing that it's purring away doing its job! It's not unpleasant on my end but I'm conscious of my fellow boaties anchored nearby. Everything else is an upside in my opinion. Soooo easy to go for a dive because the
gear is so much simpler to lug around and set up!
If you've decided to use a Hookah, petrol ones give you multiple dives per day and much more
depth. You're limited by hose length (20m). Obviously I'd expect you have already dived in the past as your life depends on that!
As for brand, I've heard of little issues with every brand except The Air Line. My own one is a beautiful bit of kit that I'm glad I bought. They are a great company to deal with.
I have a good friend who was a
scuba instructor. He used to dive with a rebreather until we teamed up and now dives with me on the Hookah. We both still enjoy
scuba but it's just so much more practical to use the Hookah. No tank fills...