We might be suffering from an incomplete definition of "low doses". If we define "low doses" as "not heroic" doses, then of course they are enjoyable. I rarely drop "heroic" (more like "idiotic" ) doses of anything.
My experience with the mushroom dose continuum (rough dosages based on my own, rather low tolerance and dried cubensis of the somewhat stronger kind):
0..0.1g - No perceptible effect. Potential microdosing territory.
0.1..0.75g - Inbetween limbo state. Feelings of being energized, focused attention, a feeling of being lost, gripping anxiety, quick and often unpleasant emotional changes.
0.75..1.75g - Low recreational dose. Mild open eye visuals, sometimes vivid CEVs and vivid visuals in darkness. Shamanic mindset, a sense of spirit in non-sentient things. A sense of connection and emotional elevation.
1.75..3.5g - Trip dose. Heavy open eye visuals, full-on CEVs, loss of sense of location and dreamlike dissolution of self. Changed body perception. Photos and pictures may seem alive and 3 dimensional. A sense of deep interconnectedness, an emotional connection to souls far away in space and time, and a feeling of observing my human life from above, a perspective beyond location and beyond individual lifetimes.
3.5g..6g - Heavy dose. Reality is stripped away. Full distortion of body image. Potential ego death. Experiences of many-dimensional space.
6g.. - Heroic dose. Everything a heavy dose has and more (or in some sense less). I have only done it once, let's not talk about it right now.
If we mean the low recreational dose, then yes, it's a great place of creativity. The inbetween dose below that, however, is not something I'd ever intentionally aim for.