Will I be able to check if the new fan settings work as intended while I'm in Windows?
(since this is a firmware modification I'm assuming it's OS independant)
Or is the fan's problematic behaviour something which is only noticeable within MacOS (10.14 Mojave)?
Technically you can see the same behaviour in Windows, as you said, it's firmware level mod.
However, AMD provide a very sophisticated driver in Windows. And most likely the AMD driver you installed has it's own fan profile which can override the firmware level fan profile. Therefore, the test result in Windows may not be that accurate. Also, the power management in Windows / macOS area also different. Therefore, you better test the final result in Mojave.
About the VBE7 fan profile editing: it looks a little confusing as to what I should change it to. Naturally I don't want to risk the GPU overheating, but I also want to reduce noise.
It's hard to tell what's the acceptable noise level to you.
My suggestion is that in Windows, either use AMD software or install Afterburner, slowly increase the fan speed manually. Find out the max fan speed (in %) that you are comfortable with the associated noise (e.g. 35%).
Then in VBE7, set the fan profile to maintain that speed (e.g. 35%) between 0°C - 65°C. Then let the fan speed increase linearly to 100% at 85°C. In this case, your GPU fan should be steady at 35% whenever you are doing desktop stuff. And only will increase when you really stress the GPU. Besides, the fan will give you full protection once the GPU temperature reach 85°C (roughly the highest stable temperature).
On the other hand, you may also use VBE7 to lower the GPU voltage to reduce its temperature.
For standard HD7950, the clock speed is 800MHz, with voltage 1.094V. Your aftermarket 7950 has even higher clock speed and voltage. I owned few HD7950 before. The best one only need 0.888V to run at 800MHz. The worst one still only need 0.925V to run at 800MHz stably
If you don't really need that extra performance at 950MHz. You may also set max clock speed to 800MHz, and max voltage at 0.956V (a very conservative voltage). This will allow your card run at a noticeably lower temperature / fan speed.
A typical Vapor-X OC boost may draw up to 1.25V, which is 30% more power than 0.956V. Just lower than clock speed from 950 to 800, and set a lower voltage, can easily make the card draw 30% less power, and release 30% less heat.
In fact, you may also try this 800MHz @0.956V settings in Windows. And only use that if your card can run it stably (e.g. 15min Unigine Heaven loop. OCCT stress test is the best for stability test, but may be a bit too extreme).
Anyway, I may be going too far. I really like the 7950, the ROM is highly modifiable, a lot of fun to playing it around.