CNBC reviewed a handful of the many "best places to go" lists issued around this time of year and asked travel industry experts for advice on the best times and reasons to visit certain cities.