The voltage between body and source modulates the drain current in similar fashion to the voltage between gate and source. The body behaves similarly to a JFET gate. For switching, it's generally fine to connect body connections to the power rails. But for linear circuits, you may want something different. For example, if the source voltage varies and the body is fixed, the gate-source voltage for a given current will vary, which may be undesirable. It may also be desirable to bootstrap the body to minimize source capacitance. I believe these considerations drove the design of some of these circuits, where the P-channel transistors in the differential amplifiers have body connected to source, even when source is not Vdd.
In common bulk CMOS processes, the body of the N-channel transistors is the P-doped chip substrate, so all N-channel transistors share the same body connection. You see this in the 4007. The body for a P-channel is an N-doped "well", and there can be separate wells for different parts of the circuit. But I believe the 4007 has a single well for its three P-channel transistors, thus a single body connection for them, too.
I remember years ago seeing a frequency mixer using the body as a gate. I can't point you at a reference. There are better ways to do this.