It usually helps most when your attic is under-insulated and leaky, because the attic is a major pathway for heat gain/loss. Better insulation can reduce temperature swings, improve HVAC runtime, and make upstairs rooms feel less extreme in summer and winter. Pairing insulation with air sealing is typically where homeowners notice the biggest comfort jump.