The bargain basement stuff is usually HSS. Carbide is a step up. I've never seen a "ceramic" bit, but I wouldn't be surprised if they exist.
The only metallic coated stuff is probably Titanium coating (usually gold) and it's not a bad thing.
Even cheap bits will work fine in wood, especially soft pine, although expensive ones keep sharp longer, so tend to cut cleaner. Thing is, if you're free-drilling with narrow (<1/8") bits and hit a knot at an angle, snapping a bit is just part of the day. The drill jerks, your hand twists, and the resin grabs. Boom. Done.
Not just knots, either - I've found staples and brads embedded in studs I've bought (to square up and plane down into knotty pine for furniture), which turned a "cheap" pine piece into a very expensive replacement blade.
The only solution I've found is to go slow, and to use a drill press or a
guide whenever it's possible.
Using a lower-end cordless drill actually helps here - it doesn't have enough torque to snap a bit, it just stops. And it tends to put a cap on how fast you can drill holes.