https://casualphotophile.com/2019/05/17/ricoh-gr1v-film-came...
https://casualphotophile.com/2019/05/17/ricoh-gr1v-film-came...
There have been some Sony camera with fixed 35mm focal length lens and FF sensor. Like this: https://www.bhphotovideo.com/c/product/1316682-REG/sony_cybe...
And theres plenty of $$ cameras with no removable lens, fuji x100 series, Sony RX1, leica Q, etc, like you linked.
https://electronics.sony.com/imaging/lenses/full-frame-e-mou...
https://www.kenrockwell.com/tech/film-resolution.htm#:~:text....
A better benchmark is MTF50, at which you can get about 50 line pairs at ISO 100-50 which corresponds to about 10 megapixels. If we want to be nice we might go as low as MTF20 where you'll get about 18 megapixels of low contrast. I'm looking at Velvia 50, the same film as Ken (https://www.ishootfujifilm.com/uploads/VELVIA%2050%20Data%20...)
Ken also makes the point that the Bayer sensor reduces the resolution - and it does - but he forgets that film has different MTFs for different wavelengths, sometimes even as bad as half for red compared to green.
And yes, you can use medium or large format film, but that comes with very serious drawbacks, and for low ISO film is literally impossible without a tripod, in which case you might be better served with sensor shift instead.
On APS-C (Fuji) or compact-design-but-with-changable-lens there are a lot more options.
What I don't like most about all my Sony cameras is the hand grip. It feels made for a robot, and I miss the nice organic shape of Canon and Nikon grips.