Is this station good for SMD work?

Yes. The adjustable temperature and stable output suit fine SMD work, and Hakko offers fine-point tips for it. You will want a narrow tip for small pads.

How does it compare with a basic soldering iron?

It gives you set-and-hold temperature, faster recovery and a stand, which a fixed-wattage iron cannot match. The trade-off is a larger footprint and a higher outlay.

Does it come with a tip and stand?

It ships as a station with a built-in stand and an installed tip. Check the listing for the exact tip fitted, since bundles vary.

Can I use other brands' tips on it?

Use Hakko tips made for this station's handle. Third-party tips may fit loosely and give poor heat transfer.

Is 100 watts too much for small electronics?

No. Wattage is headroom, not output; you set the tip temperature to suit the joint. Lower the setting for small pads and delicate parts.

Is it worth it for occasional hobby use?

If you solder regularly or work on fine boards, the stable temperature pays off. For rare repairs, a cheaper temperature-controlled iron covers most jobs.