I would imagine it may be worth it if you are doing enough of those boards per year. I believe the salesman remembered your case when he was talking to me on Friday. He said something that in less than 5% of cases was there an issue with foam fluxer specifically to do with connectors.
How long do you think these machines last when used daily 5x day a week one shift? 5-10 years? more? The design seems the same for last 30+ years. I am trying to understand what can go wrong with them in terms of mechanical problems.
Since I never have talked to novastar about it, probably wasn't my case. But everyone I've ever talked to who has run a wave solder machine with a foam fluxer has told me that they have had the exact same problem I have. You have to realize that the method of flux application for a foam fluxer involves the flux wicking up through the holes to get a good coating of flux on the pins and the hole. With a foam fluxer you don't have control over this wicking action as there is an effectively infinite amount of flux available for each hole to wick since the pin can draw from the flux foam head for the entire time the board is over the fluxer. Generally this isn't a problem on most devices because if there's a bit extra flux on and around each hole it isn't a big problem. Generally the flux will get activated in the preheat step, and once it's been through the wave it's all inert.
Unfortunately on connectors, where it wicks to is often the connector mating surface. Once that gets hot and then becomes inert, it's effectively a thin layer of insulation.
The solution to this problem is apparently to limit the amount of flux available to wick. With a foam fluxer this isn't possible - it's either there or not. With a spray fluxer you can put only a certain amount on the board which limits the availablity for the flux to wick into the connector.
I will say that although there is some truth to the satement that a different flux will solve this problem, as of 5 years ago, I couldn't find a flux which was compatible with the machine and which didn't exhibit this problem. I did consider making my own sprayer using an atomization nozzle but never went down that path.
As far as the high volume performance of this machine, I can't really say one way or another. If the failures I've had over the years are volume related then it's going to be a problem since you're probably going to run what I've run over the life of this machine through it in a few weeks. On the other hand, I suspect many of the failures I've had has been more related to just aging which means that it doesn't matter how many you put through it. I also have a SnPB pot, and I understand all of the lead free alloys are harder to deal with.