It would be great to have an ability to cast ULID to timestamptz (timestamp with time zone) directly.
Using timestamp (without time zone) is considered to be a bad practice - https://wiki.postgresql.org/wiki/Don%27t_Do_This#Don.27t_use_timestamp_.28without_time_zone.29

Additionally, TimescaleDB also recommends using the timestamptz type, as mentioned in their hypertables documentation:

Hypertables are designed for real-time analytics, they are PostgreSQL tables that automatically partition your data by time. Typically, you partition hypertables on columns that hold time values. These partitioning columns can be of the timestamptz, date, or integer types. While timestamp is also supported, best practice is to use timestamptz.