The problem is while you made the correct distinction that expensive and rare are two different things, nearly everyone on reddit or Facebook does not.
It's your prerogative to flip Godzillas. Do what you do, because you ain't buying them and the buyers are the problem. That's why I said to Doug, go bananas.
Also another thing most collectors don't know and you do - there's nothing legit rare on current systems. The closest is NBA Elite 11 and that's a full generation plus back.
To put it in perspective, as per the community gathered numbers on that Google sheet, the Switch game with the shortest non-LE production run is Double Switch with 2,000 copies. (Doug can opt to confirm, deny or say nothing).
Back in the day of the NES and SNES, when games were spread out over retailers all over the country, this would be microscopic. It wouldn't even cover 1 copy for every retailer that sold games. Blend in some loss from tossed games, close out, cases lost in a warehouse and good luck finding the game.
Now? Those 2,000 Double Switches were directly aimed at the target market of collectors. They skip the retail phase and go right to collections. While there are some copies going for play, all of these games are finding a spot on a shelf immediately. Add in copies bought solely to be regurgitated to the secondhand market and any day of the week, you can find the "rarest" Switch game for sale.
There are probably less than 50 games (over something like 15,000-20,000 US released games across all systems) that qualify as rare and majority are for the Atari 2600.