If you want the simple explanation for why timezones don’t behave as you would like, it’s this: imagine two users in the same workspace, one in Singapore, and one on New York. What is the result of Today() and Now()?
These users expect different answers, but Fibery doesn’t allow (number/string) formulas to show different values depending on who’s looking. So Fibery chooses to show the same value for both users, based on UTC (which will be wrong for both of them, but wrong in different ways!)