A "hoof" or bevel tip is really useful for surface mount soldering. If you are using a milled PCB or home-made PCB, definitely pre-tin the pads.
Buying a syringe full of flux from digikey is a great investment. You'll pretty much need a microscope or some sort of magnifier, which is a bit of an investment. But I'm sure your local hackerspace has one!
With a flat tip and flux, you can pull off stuff like this:
Other people have mentioned, but generally, aligning the module, holding it down with a piece of tape, and soldering one pad at each of the corners first is a good way to get it anchored, the fill in all the other pins.