Sorry, delayed and missed the question.....re transfer pumps on. The RFM says if caution ON, carry out drill, no exceptions. If others do something different that's up to them, the reasons given are lack of lubrication causing wear, overheating, and needlessly having electricity supplying a component in a fuel vapour rich container that could be a problem during a crash, the last is much the same reason not to have prime pumps on in flight once they have got the engines started. And of course you'll have an experienced TFO asking you why you're not following the drills!
In practice if you're performing say, a very slow orbit around the target and the pitch attitude is changing by a large degree because of high winds when into/downwind then at predictable fuel loads and Cof G the pump caution will come on and off and it would be akin to chasing your tail to keep switching it on and off every 2 minutes.