My battery in the Gulf War got in a direct fire shootout with some Iraqi armored cars and MLRS, so its not entire out of fashion yet.
See the accounts of the taking of Metz, and of Patton's Third Army's procedures for clearing towns house-to-house when it was impossible or impractical to bypass them.
The single most useful tool for putting a new doorway not covered by enemy fire or boobytraps in an existing structure was direct fire from the 155 SP guns accompanying the Infantry, also useful should a sudden stray enemy tank or armored car make an appearance, or should countersniper fire be required.
Now that the M728 Combat Engineer Vehicle is out of service, along with its 165mm demolition gun, previously useful for breeching wire entanglements, walls and urban structures, there's really nothing else quite suitable for the task. the Israelis are considering direct-fire 160mm mortars, but even 120mm main gun fire is ineffectual at such tasks- the tank rounds penetrate too well, with minimal effects on the occupants.