The FAA Helicopter Flying Handbook is a great resource that covers the physics involved with rotor flight.
Some of what you are describing is exactly how real helicopters behave. At least the ones I’ve flown in real life anyway.
Is the sim behavior 100% perfect at the edges of the envelope, probably not.
It IS pretty accurate for most of the flight envelope if you control them the way you would a real helicopter though. We may never be able to confirm if the behavior is entirely accurate because you can’t move real helicopter controls at the speed and amount of travel that you can move a gamepad or controller stick. The controls are smooth, but there is mechanical resistance in the connections of the cables, rods and cranks.
The cyclic and the collective both change the pitch of the main rotor blades. When you increase the pitch of the blades, it increases drag, the increased drag slows the rotor rpm down, the governor will then increase the throttle to maintain rotor rpm, the increase in throttle increases the torque on the main rotor shaft, the increased torque causes the fuselage to yaw in the opposite direction of the main rotor rotation…(right yaw for the 407, left yaw for the Alouette)
It is a constant balance of canceling out each control input with another in order to make the rotor disk do what you want it to do.