I have good spray foam insulation above the second floor, and it's tight as a tick. No problems here. It's even tolerable in the attic/storage space.
Oh, and the thought of sleeping at 78 degrees every night in the summer makes me ill. It can't be cold enough for me (especially with my reptilian wife that still bundles with 283 layers of blankets).