My club is private, so I'm lucky in that the maintenance staff do take pains to make the greens somewhat playable following aeration. Our greens were just aerated a few days ago... despite the light top dressing they're still very slow and bumpy, especially in the mornings with the dew on the ground.... but it's a necessary evil we have to deal with a couple times per year.
A course where I used to play got into the habit of double-punching their greens when they'd do aeration... and they always did the deepest tines. Those greens had twice as many holes, took twice as long to recover, and they always put either too much sand on them or not enough. It's basically why I stopped being a member there - they'd aerate in May, greens would finally recover around July, then we'd have good greens in July-August, then they'd double-punch again in September.
So two months of nice greens my last two seasons there. They had nary a clue about wtf they were doing, so I left.