Some thoughts..
Tiering is ok to separate "hot/fast" and "cold/slow" data but
there is a lot of storage load to move between (reduced overall storage performance during move)
The idea of ZFS special vdev (from Intel) is a different and i would say superiour approach. You separate data based on physical data properties like ZFS blocksize or ZFS recsize. This will force small/slow datablocks to a faster device or you can force some data with a recsize setting < small block size to a ZFS filesytem on a faster device (ex NVMe mirror).
For these data (based on physical blocksize or selected data per ZFS filesystem) you get full NVMe read/write performance,
https://www.napp-it.org/doc/downloads/special-vdev.pdf
btw
Slog is not a writecache.
When sync is enabled writes are always slow but your rambased writecache is protected. For filer use, always disable sync and forget about Slogs.
Writecache on ZFS is RAM (nothing else, 10% RAM, default max 4GB on Open-ZFS).
10G (1GB/s) write performance without sync is no problem for a ZFS system based on discs, with Intel Optane even 10G sync write performance is achievable ex
https://napp-it.org/doc/downloads/optane_slog_pool_performane.pdf or
https://napp-it.org/doc/downloads/epyc_performance.pdf