I always was under the impression that it was best to plug aerate in the fall. Since you usually seed at the same time, the holes work to trap seed. I also thought that aerating in the spring - since weeds are blooming, gives them a better chance to grab hold because of these "seed holes". Using a spike aerator is supposed to reduce this, while still helping the compaction issues. Don't think there is a hard or fast rule - if the soil is hard you're better to loosen it up, and just deal with the weed issue - if any
Same with de-thatching - generally done in the fall prior to overseeding, but shouldn't hurt. May hurt the appearance though, and may not recover before the dry season hits
No expert here - just read this and it is also how the lawn care company (when I had the service) did it, so I follow suit and have decent results.