I think it would also be helpful to note a couple other items as well that I've run into when trying to make this decision.
This may sound obvious, but it's worth stating - partition filtering does not work with Liquid Clustering. In order to configure partition filtering, you need to filter on a partitioning column. By definition, Liquid Clustering is an alternative to table partitioning, so it sets clustering columns, instead of partitioning columns.
Tables with Iceberg enabled do not support partition filtering.
Dynamic views do not support time travel / history / version queries, nor do they support change data feed / streams
