All nights offer much the same experience. Fridays and Saturdays, and the nights nearest Halloween itself are always most popular, so book early to avoid disappointment.
Other nights, especially week nights in the first week may be less busy but this offers a better chance for groups to keep a good distance from each other and thus a more spooky experience.
The preview weekend and selected Sunday and Wednesday nights have significant price reductions, particularly if you book online.