Perhaps surprisingly, I agree with your entire comment from beginning to end.

Sometimes mmap can be a real win, though. The poster child for this is probably LMDB. Varnish also does pretty well with mmap, though see my caveat on that in my linked comment.