I have had some great insights when I can't fall a sleep, in that brain fog you mention, sometimes where the feeling of my own self somehow disappears, seeing everything less through the lens of the self-protective consciousness, then I could suddenly understand and solve some nagging issues.
But the toll is high, not sleeping properly ruins your life. And most of the time it's definitely not insights, but the opposite. For me, it's not something to seek out.