Hey ! i donīt think it has a direct effect, but i am quite sure from my experience that if you look deeper it can open the doors of curiosity and exploration, and this, can make you a more knowledgeable person in many ways.

One thing I believe we can all agree on is that lucid dreaming at least make you cognitively smarter in the sense that you understand that you are dreaming
I disagree here, but i am not sure what you mean. I donīt think lucid dreaming, per se, makes you smarter, but that would be a good experiment with lots of confounding variables.