I bought both the "Retro Fighters Brawler 64 Wireless Bluetooth NSO Edition" and the "Retro-bit Tribute 64 2.4 GHz Wireless Controller V2", and I am happy to report that both are great controllers, and they both work at the same time as player 1 and player 2 without having to do anything fancy.
So far the advantage of the Brawler 64 is that I like the way it feels in my hands better, although I quickly get used to the Tribute 64, so it is not a big issue. It also is Bluetooth so it does not require a USB port. It works with both X-input and D-input mode. It supports rumble.
The advantage of the Tribute 64 is that in addition to 2.4GHz wireless, it also works with a real Nintendo 64 console. I had to first hook up the USB dongle to my Windows PC before I could get it to pair properly with the controller, and I put it in X- or D-input mode. Also, I tried it with my real N64 and it works great, and the rumble works which is nice. I also have an older N64 version of the Brawler 64 that does not have rumble, so the Tribute 64's rumble is a nice additional feature if I want rumble for a wireless controller on my real N64.
In summary, both controllers have rumble support. The Brawler 64 is bigger and more comfortable to hold, but some may prefer the feel of the analog stick and front buttons better on the Tribute 64. Neither is bad in this regard, and I am happy using either. My suggestion is if you also have a real N64, get the Tribute 64 so you can have additional controllers for it. If you are just getting a controller for the MiSTer, then either option will work fine and are almost equal, and I will be keeping both so I have 2 players worth of controllers for the MiSTer.
Other options that I know of but haven't tried are the Nintendo branded "Nintendo Switch Online Nintendo 64 Controller" that is shaped like the original N64 controller, several third party USB N64 controllers that look like the original, and several real N64 controller to USB adapters such as those from raphnet.