First off you can weld with a soldering iron, just touch a grounded tip to a live high power line.
As for tips I have to agree with others this is a personal thing. What is best for you will come with practice and frankly no one tip fits every need. Personally I use a chisel tip for a lot of soldering and the sad reality is I got good with such a tip as that is often all I had. If making a choice to outfit a soldering station at least one tip/iron would be a chisel tip of some sort. The second would be a somewhat stubby or blunt pencil point ( a pencil point that isn't extremely long and thin). The third would be something optimized for drag soldering if I got use to it. Someplace in there would be an iron/tip optimized to put out more heat.
The thing here is that even SMD's come in a variety of packages, and some times they require more soldering capability than the traditional equipment used on fine pin SMD's. These could be heavy pins or tabs that don't respond well to low wattage irons. That doesn't even include the other SMD mounted stuff, such as board interconnects, wiring headers and so forth that require a bit more heat than an SMD logic chip. This is where Soldering Irons are a lot like DMM's, it is very easy to need more than one for a variety of soldering jobs.
This probably sounds like I'm having fun spending your money, and you would be right - it is fun. However I believe everything I've posted is accurate. The big point is personal preference gained from lots of experience. The second point is that it is highly unlikely that you will get by with just one iron. I can assure you that using the wrong iron/tip is something we have all done to finish off a project. However it is less than ideal and sometimes just doesn't work. I'd start off with a smallish chisel tip though.
Dave
The most common mistake made when selecting a tip, especially so for SMD, is making the assumption the tip must be small. This may help when soldering very small components, for example 0402 devices but the smaller the tip, the more difficulty you’ll have when attempting to drag solder IC leads. For that task, my go tip is a basic 2-3 mm chisel to hold the solder.
attention Watts, I have clearly divided the choice of the tip into two types of soldering: drag soldering (tip about 2 mm) and soldering of the single smd pin (0603 or 0402); the small tip I would use only that solder small two pin smd
thanks