I've released tons of comparison articles over the years, including a whole series of headphone and headset comparisons under the name "Headphone Showdown."
I also write end-of-the-year list wrap up articles each year with my favorite tech and games I reviewed across several categories, like this one:
Or this one:
Or this one:
I could keep going but I think you get the point! I'm not surprised you haven't run across these in reading my stuff (thank you very much for reading by the way!) because Medium's algorithm doesn't always do the best job of pushing all of my content in front of all of my followers. It tries to organically figure out what you might be interested in and go from there.
I agree that these list-style articles sometimes do better than "standard" ones but I think they also play to a different audience, and I want to capture someone googling for specific product info as much as I do someone looking for a ranking. I also don't personally always have as much fun making a ranking list as I do other types of content, but I'm glad that it has worked out for you!
If you're looking for a great keyboard to buy right now, the hobbyist/enthusiast stuff is still ahead of the curve compared to the gaming models, so you'd have to dive down the r/mechanicalkeyboards rabbit hole and check out some of the keyboard-dedicated Youtube channels to find a good deal.
If you're okay with a mainstream gaming model, the most up-to-date recommendation I can give is for the Razer Huntsman V2 series. They have the same fast performance as the originals thanks to their optical switches and new khz mode and they now have damping foam inside which makes them sound better than basically every other big box gaming model. I'm testing the TKL version and it's great....best performing gaming keyboard I've ever had on my desk.