Yup. Like others, it varies a lot. Not always with mood. My artistic appreciation and vision tends to do best when I'm hypomanic, but not always. I get creative blocks even then.
Executive function seems to take a dive at both extremes of the mood scale, and quite often when I'm in a normal mood too. But that may have something to do with psychosis which I have independently of moods at times. That makes putting together complex creative works quite impossible until I emerge on the other side of the cognitive slump.

Lately I have been surviving on the pull of creative work, and struggling to get the planning aspects of daily living and social initiatives to happen.