Great article!
I think the Lakehouse.Contents() default behaviour is to query the SQL Analytics Endpoint, if querying a delta table in the Table section of the Lakehouse.
reddit.com/r/MicrosoftFabric/s/55pqnnGhWz
reddit.com/r/MicrosoftFabric/s/PgWSz1bHwl
As you mention, and as Chris Webb wrote in the blog you linked to, using Value.Version can force it to bypass the SQL Analytics Endpoint. I guess query folding won't work then. And we would also need to know which table version number to query.