“At least throughout history the Catholic Church has beautified and elevated the architecture and aesthetics of the cities they inhabit.”
The church did a lot more than build monster cathedrals with all those tithes. It bought farmland and had people who had not a lot to piss in or a window to throw it out work the land and keep a certain amount for themselves. This resulted in a sort of middle class that could live decently and increase their estate if they worked hard and were careful. Beyond that the church had some hundred and fifty feast days that gave workers time off from their labors.
Catholics do not tithe. They make free will donations or not. I would be very happy if all of the artworks that are in storage were sold little by little and the proceeds used for charitable purposes, or even for pensions for the people who have worked in the Vatican or retired priests and sisters around the world.
I have been to the Vatican Museum and the Sistine Chapel. Both are incredibly beautiful, but I don’t see the reason to keep all the artworks that are in storage because there is no room to display them.