In my experience, in aircraft which have fixed pitch propellers, the RPM gauge generally shows engine RPM (which is the same as prop RPM on some aircraft, depending on whether the prop is geared down). On aircraft with constant speed (variable pitch) props however, the RPM gauge generally shows prop RPM (which again may or may not be the same as engine RPM). This is just what I have seen on light civil aircraft which I have flown or ridden in. I don't know for certain whether this is also true of very high performance applications or our AH models.
For me, the easiest way to understand the relationship between manifold pressure and prop RPM is that manifold pressure is an indication of engine power output, and prop RPM is a measure of how efficiently that power is converted to thrust by the prop at a given altitude/airspeed.