A question for those who know: How is SPICE used in integrated circuit design? What is it good for? When is it not useful?

The video version, the event at the Computer History Museum described in the article

https://www.youtube.com/watch?v=Ta0KiizCRzI