RPM = 3.82 x cutting speed of material (SFM) / diameter of drill
80 is a good general surface speed for most common steels. You can easily Google cutting speeds for basically any material.
Ex: don't run a 1" HSS drill bit through steel at 1000 rpm.
3.82 x 80 / 1 = 305.6 you can get it pretty damn close at 300.
HSS will have the slowest cutting speed, cobalt/TiN coated can run a little faster, and carbide can usually run 3x RPM of HSS.
Don't try to shove it through the material, just ease down on it and let the drill do the work. Chips tell you a LOT about what you're doing when removing material. Heat (overheating) is basically the enemy of everything when it comes to longevity.
Of course, a lot of this goes out the window when drilling by hand or in an awkward spot. When using a drill press or mill, it definitely helps.
Then you get in to drill materials, coatings, split point (135°) vs standard (118°), and HSS rpm vs cobalt vs carbide tip vs solid carbide. There's something for every application
Split point drills don't like pilot holes. Standard web drills do and more so when drilling bigger sizes. If it's a thick material or when using a standard web bit, I'll generally center drill first so the drill doesn't want to walk. I'll also peck drill instead of just letting it eat. It clears chips and reduces heat buildup.
You'll be fine with HSS, cobalt, or even TiN coated bits. I would only use carbide in a mill or drill press. They're very brittle and don't take kindly to side loads, but will last a long time when used properly. Gotta have a diamond wheel to sharpen them though. Not generally worth the hassle for most folks.
I'd probably have two separate sets. One for the drill press and another for hand drilling. So long as the stuff in the press is clamped down rigid and feeds/speeds are good, they'll last you a long time and rarely will you really NEED coolant, but a dab of lube never hurt anybody. I do like a good paste or wax over a liquid. It makes cleaning up a little easier because the chips get stuck in it.
There's some good, machinist word vomit for you!