Just like most things in this world, there's ALWAYS more to the story, caviats, exceptions, and alternatives, and things that you can't do, but you can get away with anyway if you've developed a good feel for it, but here's what I've boiled it down to.
Hand taps are the simplest to make, cheapest to buy, and most readily available. You must back them up to break the chip however. They are what they are.
Spiral POINT taps (Gun Taps) will "shoot" the chip ahead of the tap. This type of tap, in a three flute design, is the strongest you're going to buy. (Staying in the more common range, let's say #8 through half or five eights inch...). You can power these through a hole without stopping, or into a blind hole IF you leave room for the chips. You can hand tap with them, choosing to, or choosing not to back them up, depending on how the material feels when you're tapping. (The chips "flow" better under power than they do by hand where you have to stop to reset your grip on the tap wrench). I don't know if it's a universal fact or not, but I also feel like when hand tapping, they are in general (with exceptions) more "free cutting" than a hand tap.
Spiral FLUTE taps are for power tapping. You can hand tap with them, but they're not as strong, like for like. You can NOT back up with them to break a chip when hand tapping, as you need the chip to stay together, otherwise they jam. In other words, if you have to stop and back up, you have to back all the way out.
For my needs, I've all but given up on buying hand taps. For general purpose/keeping the cased set full, and the little boxes where I keep mulitple spares of very common/mission critical sizes, I buy spiral point. Maybe something with magic metallurgy and fancy expensive coatings if I use it a lot, or for something in particular, or maybe it's an oddball that I use once in a blue moon, I don't care if I have to replace it after not enough uses, I might get a cheap one. But for general use, spiral point (gun taps) with three flutes seems to be the best "ready for anything" tap out there. Hand taps are mostly (for me) best suited to purchase and grind myself and emergency bottom tap, which I hardly ever need, but when I do, I tend to need it right now. (And chasing rusty threads, which ruins ANY tap very quickly). They're cheap enough and quite adequate for that. Spiral flute taps, they're useable, but they're only good (in my experience, others may vary), for tapping under power, in materials that will produce a continuous chip. And they're great for that. So I only order them when I know I'm on a project where I'm going to be tapping a large number of holes in the drill press, and my go to (the gun tap) won't cut it. Which is honestly pretty rare. But they are great when it's exactly what you need.