This issue is going to be addressed by HHH-10399 which will add support for a TimeZone setting at SF/Session-level. This way, the legacy TimestampType should also benefit from this setting.