The Powerwall 2 has liquid thermal management, so at a minimum it has pumps and fans. I'm not sure if it has active cooling/heating or not. I put mine in the garage, and they're a lot quieter than my EV's are when they charge. The fans only kick in under load, and they're variable speed, but even with my stack dumping 15kW into the house, they're not obnoxious in terms of tone. If they were mounted on an outside bedroom wall, I think they'd be fine. An A/C compressor is certainly much louder. I concur that they ought to be placed indoors in this climate if possible, or otherwise well-shaded, to maximize longevity.
My impression of the Powerwalls is that they just work. If you have enough of them to handle peak current demands, and enough solar to keep them charged, you can run off the grid quite easily. I've gone as much as six days with the grid disconnected, still charging my car, cooking, running A/C, etc., with cooperating weather. With crap weather I could still go indefinitely off-grid and keep some lights and the refrigerator and a couple other minor things running, but it will not be a luxury lifestyle.
If Tesla wants to use Delta solar inverters on your job, run away. I have two of them, and one has partially failed twice (in just a few weeks each time) and the other one has issues. It takes months to get through the support process to get replacements.