Apart from tow vehicles with very long overhangs, so the leverage created is a significant multiplier of the increase on the rear axle, and reducer of the front axle loads, differing noseweight will not be much of an influence on the tow vehicles stability.
The undoubted instability in towed combinations from using too low noseweights IMO is driven by the instability arising in the trailer, not the towcar.
Clearly, once the trailer develops instability this will quickly destabilise the whole, including then the tow vehicle.
Myself I am a big fan of using short overhang vehicles for towing, other factors like for like, and very much in the camp of using substantial trailer noseweights, particularly with things like caravans with high centres of drag.