If you have limited time, focus on The Wine Experience and one additional lighter museum, such as The Chocolate Experience or Planet Cork. You'll also have enough time to enjoy an included tasting session.
WOW works well year-round because most exhibitions are indoors. Late spring to early autumn is the best period for terraces and skyline views, but it also brings busier mid-afternoons, more weekend traffic, and stronger demand for popular museums and sunset dining.
Cooler, rainier months are often easier for a museum-focused visit, since you get the same indoor exhibitions with less dependence on clear weather. On wet or foggy days, the main trade-off is weaker terrace views, so prioritize the museums first and treat the viewpoints as a bonus.