Will adding attic insulation actually lower my energy bills and make the house more comfortable?

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.