I have the Sony RX100 V (M5). I've been very happy with it for a compact camera I can ride with.
You can't really use auto-mode for most action shots for mountain biking, often in low light. But its not hard to just use the shutter priority mode if you don't want to mess with too many settings.
If you view the PB photos with that camera tag selected, most the photos are from me and many are action shots. https://www.pinkbike.com/photo/list/?camera=9566