I would say September is a good time to go, not too hot or cold, low crowds and not in peak season as all the kids should be back at school after the 1st week.
If you wanted to see the fireworks etc you would have to go in the Summer season, parks are open later and lots more entertainment but this is peak season so more expensive and very busy.