I just got a backup ISP at home and connected fiber directly to Mikoritk using SFP dongle instead of the box provided by ISP.

Scripts on RouterOS handle network checks for failover, DNS updates, etc.

I got that Mikrotik home router 10 years ago and it is still performing great and handles most of the use cases without issues.