That depends on your destination. Major holidays can sometimes be a fun time to visit because it's very festive, but it may also be very quiet if local businesses and tourist attractions are closed and locals are away on vacation.