I think epiphanies are best thought of as fuel that gives you a short burst of "actual power", whatever that means.
Reminding you to get off your arse, yeah. I have a few favourites (e.g.) that I find useful for this.
I enjoy LW and it does remind me to try not to be stupid. As I've noted, I'm not entirely sure the outside view would see any practical effects.
LW doesn't seem to have a discussion of the article Epiphany Addiction, by Chris at succeedsocially. First paragraph:
I like that article because it describes a dangerous failure mode of smart people. One example was the self-help blog of Phillip Eby (pjeby), where each new post seemed to bring new amazing insights, and after a while you became jaded. An even better, though controversial, example could be Eliezer's Sequences, if you view them as a series of epiphanies about AI research that didn't lead to much tangible progress. (Please don't make that statement the sole focus of discussion!)
The underlying problem seems to be that people get a rush of power from neat-sounding realizations, and mistake that feeling for actual power. I don't know any good remedy for that, but being aware of the problem could help.