So an update on my Y. On Friday afternoon I took the car in for my service appt. They were able to successfully fix my rattle (though they did charge me $102 for the rattle fix despite quoting me $0 beforehand which is its own story).
Initially the service advisor said they "remotely" accessed my car logs and didn't see anything wrong with my car's ac system, telling me my Y ac blowing warm and the high energy usage is due to the record heat and car prioritizing keeping the battery cool, which does make sense. After I showed the SA this thread's energy usage reports and my S's energy usage reports which all reported much lower climate energy usage driving in similar 115-118 heat, he did come out to my Y with me to do an "test ride."
During the test ride, he put my AC on low temp, max cooling and he noted how after 5 minutes the air coming out was still lukewarm which is outside the norm. Thus, he promised to have the tesla service tech do an hvac performance test during my service.
When I picked up my car Fri night 3 hours later, I was told Tesla reset and updated my heat-pump firmware and after that, my car passed both the "thermal" and hvac performance test.
My Y's AC does feel it's blowing noticeably cooler air set at my same 69-70 auto climate setting driving around in 110-115 heat this past 4 days (though that might be a placebo effect). And today, during my commute, running the energy app, it did use less energy for climate (10.5% out of 29.4%) vs my commute last week which used 18.3% out of 36% on climate. However, today was a high of 108 vs the day last week when I recorded the extraordinarily climate energy usage, the high was 115. So the energy savings may well be due to the 7 degree temp delta.
So results are inconclusive if the heat-pump firmware update was a true fix on my energy hog Y's AC. When Phx temps climb back to the 114-116 highs again this weekend and next week, I'll try to take some more snapshots of the climate energy usage reports and see if the high climate energy usage issue is resolved.
Thank you for everyone who chipped in and contributed data points on how their tesla car's AC has been consuming energy during our record breaking heat wave in July!