Roger. That's pretty detailed, and an excellent critique.
I can't say as I agree, completely. But, some of your points I've raised myself, like it feeling "clunky", but I don't see how you get around that with a fat rotary mag. Your other options are a tube mag, stick mag that protrudes below the action ala Savage 64/Marlin 795 or figure 8 mag like the T Bolt. Each has it's own design and use trade offs.
The bolt lock is bonkers lousy. if they scrapped it and saved the production costs and included a chamber flag instead it would be a far better solution. I grew up learning to shoot on old Mossberg semi autos that didn't have a last shot hold open either though. I learned to count shots, and I would argue that's actually one of the important bits. I can say it actually served me well later in life in an army career. Knowing whether you have 15 or 5 rounds left in that mag and should drop and reload or keep it in for your next engagement is a pretty good skill to have developed from youth. Mag release I've never had an issue with, push forward with my index finger in front of the trigger guard and it drops free. The drop at comb is a lot from a modern perspective. If that's an issue, there's plenty of offerings that solve that. I don't find it an issue. I have a 4-12×40 on Leupold PRW lows on top of the rail that came with it. I don't find any need for a higher comb, and I like a high cheek weld, not a chin weld.
Love the Nylon 66 too, another .22 I grew up learning to shoot on. Nothing between them and the 10/22 apart from modularity and wear and tear on old 66s, but that's not their fault.
Dunno about the front sights, not to discount it but mine drifted fine for adjustment with light taps. Then I stole it and put it in my 77/44 while I had another on order. I don't know how you would de index your barrel driving a sight out unless you were a total goon. There's no need to apply any stress to that junction. If there was, the answer is simple - remove the barrel first. But I fail to understand how you could twist a barrel relative to the receiver by driving out a front sight unless you're a mechanical rapist and doing it very very wrong. I find most other stock semi .22 triggers in the same price range to be distinctions without a difference, they're all about the same quality. Some easier to tinker with others. A modicum of skill and a drill press and a few hours you can DIY mod a Marlin 795 trigger to be pretty good. Certainly better than a stock AR trigger anyway. It's a function of the price range. I will confess to having no experience with the 597, and I'm going to rectify that.