As a stomach sleeper I accidentally stumbled on the solution for me. My wife and I bought a king sized bed with individually adjustable mattresses. The mattresses are essentially two twin sized mattresses with the bed frames bound together at the head and foot.

I found if I adjust the binding strap at the head end of the mattresses to leave about a 2”-3” gap between the mattresses, I can lay comfortably face down with my face between the mattresses. It’s essentially like the hole in a massage table for your face. I use a thin, hard pillow across the gap to support my forehead which offloads the pressure on my cheeks. The gap is wide enough that plenty of air circulates.

Before discovering this arrange, I used to spin in bed like a rotisserie chicken. Now I’m comfortable all night and wake up with zero aches and pains. When we first bought the mattresses I hated that discontinuity between the mattresses but now I love it.