I have not received any feedback or comments to the above query from core maintainers. As the profile is one of its kind (dealing with UoM two directions), it might remain a niche use case
As such, gain offset profile is broken with recent openHAB versions.
One can workaround the issue by using eg 2 different javascript functions to scale to/from item