In the code that sets the default value (@now) of ChangedAt, RecordedAt, and ErasedAt the chronon used is, however, a datetime2(7). This can be changed on a local installation of the tool, by modifying the file SQLServer.xsl and the following section at the beginning of the file:
I haven't worked with datetimeoffset, so in the best case it may work just by specifying your default values in the tool to datetimeoffset, but in the worst case you may need to change the chronon and perhaps also how @now is set to include the timezone of SYSDATETIME().
I do not want to make a special 'local' version of the modeler. Your reply seems to suggest it may be as easy adding a setting in the modeler to select local or UTC times. Then, change the sqlserver.xsl file to use SYSUTCDATETIME() instead of SYSDATETIME() for the default value of @now. Agnostic timezone is very important when event times need to be communicated across timezones (think cloud computing).