Reddit mentions of TekLine T245 No-Clean Solder 63/37 .015" Dispense-Pak

It looks like you have a decent soldering station, that is really the main thing. You'll need a small tip, but probably not as small as you think. I like the Weller ETL, but a ~2mm screwdriver style tip works well for SMD in my experience. If you go too small it can actually cause trouble for heat transfer and thermal recovery.

If you've mostly been doing through-hole stuff, you'll want smaller solder. Having small diameter solder makes it easier to feed just the right amount. I like Kester 0.020, some people go even smaller. Of course there are lead-free versions of that, too, if you prefer.

For through-hole, the flux that is inside the solder is usually enough, but for surface mount, you'll need extra flux. You'll probably be fine with a flux pen. You'll probably want some solder wick because mistakes happen, and a solder sucker thingie doesn't work as well with surface mount.

As u/t_Lancer says, you won't need a hot air station and solder paste unless you're planning on doing leadless packages. If you decide to get a hot air station, though, they're pretty cheap. You don't even strictly need solder paste, I've been making do by tinning the pads with regular solder first with my soldering iron before hitting it with the hot air.

For vision, it depends on how your eyesight is. I'm fine eyeballing down to 0603 but I can't read the markings without help. I've started doing all of my soldering under light magnification with the Optivisor DA-3 with a LED attachment which has really helped, but it isn't strictly necessary. You can get those visors with more magnification at the cost of a shorter working distance. Good room lighting and a magnifying glass work fine, too.

And most important thing you need is practice. Watch this video and grab one or two of those SMD practice kits and you'll be knocking out surface mount stuff in no time.