UPDATE: Guide here: https://thefunnybrain.com/2022/11/16/shader-magic-walls-fade-to-show-the-action-with-explanation/
I made a shader in shadergraph! The opacity of part of the object is set using the camera rotation in relation to it. This leads to a nice effect where the player can hopefully see what's going on in the game, but still get the feeling that this is still a building! :)