I could overwhelm my RB4011 easily with a 400M WAN link using VLANs and badly configured mangle rules/queues. CPU is relative.
Anyway, to answer your question clearly: There is no best queue type. It's the word "best" that made me reply and hype in general annoys me. When someone has used two things in specific scenarios, it's easy to pick a winner. It can also be very misleading like a lot of advice and opinions given online. I'll admit that if someone posts numbers, I'll look at them, but I won't base any decisions on them without carefully testing everything myself (even when it's a peer reviewed research paper).
Old school FIFO is still used for a reason (a simple or "worst" discipline) and contrary to popular comments online, it's not because hardware manufacturers are lazy even though large FIFO buffers are the main cause of bufferbloat. Here are my results: On my network, bFIFO works better combined with small buffers and a parent SFQ than CAKE ever has because I prefer to drop packets from various iToys, console downloads, MS update and torrents clogging up my network when
I absolutely need stable low latency for work. I have zero critical packet loss and A+ on bufferbloat tests.
Do I believe that SFQ is better than CAKE? Absolutely not, but it uses a lot less CPU time because (it's a "dumb" fair queuing algorithm).
BTW, I have used FQ-CoDel at home on various routers for years and CAKE when it was released in 2017 on OpenWrt. I can't imagine CAKE working much better with MikroTik despite all the nagging for it - it is what it is i.e. a great tool to have for simple congestion management on home networks. Maybe RGB CAKE would solve it all for me...
Or maybe someone else has magic powers that I do not and will post the holy grail of all QoS strategies...or you could grab a few cold ones and have fun on your next day off and post your own numbers
You might find this thread relevant:
viewtopic.php?f=1&t=178913