I’m typing this on a Sidewinder X6. I don’t use it for MSFS, but I certainly wouldn’t have a problem doing so. My Mom needed a lighted keyboard due to her failing eyes, and I briefly thought about giving it to her - especially since she doesn’t want or need a numeric keypad (the X6’s is detachable.)
But I just didn’t want to give this one up, so I bought her something else. I wanted to get her a new keyboard, but couldn’t justify paying for a new X6. I see them going for about $190 now. I think I got mine years ago for $90. Used keyboards are a gamble, and I suspect OP would be leery after his recent experience. Might be worth a shot, though. They’re pretty cheap on eBay.