I mostly do SMD. I find the CF tips most useful. I have 'em all. The 2.5mm CF is probably what I consider my default tip. This is what I use for gullwing parts and SMD passives and LEDS and whatnot, and I find it is also fine for most thru hole and wire splicing, too, if you are the kind of person who rather apply flux to the joints than to feed solderwire.
I find 2-3mm regular "nekked" C/bevel is the bees knees tip for hand soldering QFNs with side pads. This is a bit niche/specific, though. And my current 2.5mm CF* has worn the chrome on just the right spot where I don't have to hardly use a regular bevel, anymore.
Knife tip has few good uses for SMD, particularly rework. It will lay out a ton of heat when you use it along a row of IC pins, so it can be useful for lifting chips with the solder blob chipquik methods. And for removing passives, it will be able to do that without adding any extra solder, in many cases, because it's able to get down to the edge of both pads at once. With the bevels, you often have to add a solder blob.
If you're a solderwire feeder, then chisel tips and regular bevel tips are probably where it's at.
*actually it's a CSF, S for short... cuz it's shorter/stubbier than the other tips giving it better thermal characteristics; the newer T12 tips have all gotten shorter and stubbier than the 888 tips, since SMD soldering doesn't usually need much reach.
I could pretty well do just about anything with just a few tips. CSF25 for almost everything. CF1 or CF15 for tight point to point bodge wiring. Then a regular bevel or chisel or bevelled conical or... well, something hot but not too pointy for thru hole solder-feed jobs like lots of pin headers.
So first off, you have to figure out what kind of solderer you are. A feeder or a fluxer. Lots of people are solder feeders. They invent things like hold downs to hold parts in place while they solder them. They use third hands and special vices and stuff like that. They have 15 different sizes of solderwire. Some of these folks think liquid/gel flux is a scam to part dummies from their money, and that the flux in the solder is all you ever need. Feeders tend to like nice concave filets. They find this to be very important for esthetics and functionality. The electrons flow better this way. They consider every joint a masterpiece of attention and detail. Drag soldering is the devil. Every feeder needs to have a bunch of chisels and an extensive collection of long pointy I and B tips plus the requisite pointy bent conical for "reach" and "precision."
If you're a fluxer, you might want to try some bevels and CF bevels for SMD stuff.