sfp might be an issue for my since my modem and Ap don’t have that port
SFP is something like a port for ports - you buy an SFP module based on what port you need, so you can just buy a network device with SFP cages that can handle your required speed and then pick a combination of Ethernet / optical SFP modules that match your needs. But the modules aren’t exactly cheap, even the Ethernet ones.
Mikrotik is awesome. They are super powerful and super flexible.
But they don’t hold your hand, and have a hell of a learning curve.
Luckily, the quick-set default config thing is actually decent these days. So it’s easy enough to get a basic setup going, then figure out how the bridge works, vlan tagging, where to add IPs, DHCP settings, DNS whatevers and all that.
It took me about 6 run through of setting it up before I stopped locking myself out accidentally! Probably another 6 before I was confident setting up a new vlan with routing/DHCP/etc.
Just be aware that there are a lot of popular tutorials out there based on older versions of the software, and older ways of doing things. Look for videos from 2022+