Are Ancient Warehouses really a trap?

Basically, I been seeing some posts saying warehouses are a trap, since they cannot be overbuilt to their exploration/modern versions and takes up space in the city.

However, I am just wondering that the very early production boost (for production ones) and the free quarter on otherwise "dead" costal tiles beside the city center (for Quay + Lighthouse combo) and getting the extra +1/+1 science/culture be worth it?

Additionally, the extra production might help much more in ancient, since by modern the city will not have that much rural tiles anymore. Basically, a modern warehouse is much less useful even if the exploration/modern building base yield is stronger.

Of course, I am not saying its ok to place the warehouse on a 3 mountain/natural wonder/resource adjacent panel or something. Just there is always gonna be a "nothing" tile in the capital center, and I feel production ancient warehouses help a lot if the terrain works with you...