In Rate/Acro+ mode, in forward flight, you are banked forward with sticks centered and the camera is looking a little down. When you rotate yaw, the plane of the quad stays the same (that is what yaw is) so your camera is facing backwards and pointing a little up.
Imagine if the quad was banked 90 degrees forward (rate mode and sticks are centered, it does not automatically level out). You are high up, but sliding edgewise downward. You are looking straight at the ground. Imagine giving 180 degrees yaw and nothing else. You are now looking straight up.