Philip both google and cloudflare honour TTL values, even as low as a few seconds. The original point made was in reference to the number of lookups been carried out. In addition its been a long time since i seen any UK ISP's DNS not honour DNS records.
Unbound the resolver on pfSense will still cache records locally in forwarder mode, so any reference to caching performance is the same in both configuration's, if you are in forwarder mode, it does not disable the cache so if something is cached at 1ms, it will be cached in both modes, the difference is in uncached performance, unless you are using serve expired or increasing the min ttl overriding the domain's expiry, in a typical home family environment there will be a high miss ratio. In this situation both configurations will send out the queries over the internet, in the forwarder mode the query will be sent to a DNS cacher, such as isp DNS or google DNS, those due to their high levels of traffic will very likely have the record in their cache for popular domains, it is effectively a level 2 cache in this respect.
If I came across as saying this would be faster in every single use case, then I apologise for been misleading, as I never intended to say that, my intention was to say in a low traffic environment the miss ratios will be higher on the local resolver, and as a result more queries get sent upstream. Its the queries that get sent upstream where the behaviour is different. If you have a forwarder configured, you effectively have a level 2 cache, a second shot of hitting a cache so to speak, the hit ratios on large public resolver's will be high due to the sheer amount of traffic they have.
This explanation is not intended to say it will always be faster, which might be why you think I posted it, but it is to explain why I posted that advice.
I have contributed code to the development of Unbound (the DNS resolver that pfSense uses), and to pfSense itself in its DNS resolver implementation.
The issue I have with your posts is that you seem to have decided to go on a personal tirade against me, when all I did was reply to try to answer a question you asked, Alex disagrees with my advice which is fine, but he hasn't acted in the same way as yourself.
Bear in mind this is a topic on a specific VM problem, the guys in here are trying to resolve an issue with latency spikes whilst using pfSense and it got discovered this was in relation to the behaviour of the resolver. This may make no sense as to why the change of configuration has such an impact on that, but it does.