I believe the OP was thinking about tweezer-style tips for the soldering iron itself, while Kleinstein may be talking about "cold" tweezers just to position the components?
To solder passives onto the board, I can't see how soldering tweezers would be helpful. Wouldn't it be very likely that you drag the component along or pull it upward the moment you lift the soldering prongs, while the solder is still molten on both joints? Personally I prefer using solder paste and hot air when I have to populate multiple small passives. Or I hand-solder them one side at a time with a conventional iron, holding the component in place with tweezers while I solder the first joint.
For unsoldering, I find that actually gets easier for the small 0402s: You can heat both joints at once by holding a flat tip to the long side of the part, then lift off or push away the part. I have felt more of a need for soldering tweezers with larger parts where I can't otherwise reach both joints at once. (But then I'm cheap and just a hobbyist, so I simply use two separate soldering irons in those cases...)