I"m not sure why you say Best isn't suitable for every variable - if you choose Best from the Transform Variables node, it will try several transformations for each variable (Log, Log10, Sqrt, inverse, square, exp, standardized, range) and choose the one for each variable that is most correlated with the target. Alternatively, you can pick Maximum Normal, Maximum Correlation, Equalize, Optimal Max. Equalize for it to try several Box-Cox power transformations and then pick the best for each variable in terms of what you pick to maximize.
... View more