re: stages of meditation, sure, energetic experiences will come soon after starting a retreat, but in my experience, while interesting events will happen, there was a certain grind to a 5, 7, or 10 day retreat that left me feeling more bored out/raw than realized.
Don't do retreats anymore, drawn fully back into the world, for better or worse, not sure ;-)
Repeating myself, but the same goes for the great mystics past & present. As to what they did prior to awakening, perhaps some did take hallucinogens, but given that none of the extant teachings suggest ingesting external substances, we can conclude that hallucinogens are non-essential to awakening.
In the west, where materialism reigns, many of us grow up spiritually bankrupt and turn to strong experience (hallucinogenic intake in my case) as a means to fill the void. Provides a much needed break from technology and rational thinking, but not convinced that this does much more than spin the wheels in place.
A good (albeit possibly apocryphal) example would be Jesus. His epithet was 'the anointed one', because he regularly covered his body in an oil that contained enormous amounts of cannabis, among other psychoactive ingredients. (At least a according to several linguists.)
"and here I sat several retreats with dagger-like pain in the knees, wandering mind, and a deep desire to somehow exit stage left unnoticed."
You're not going to have a mystical experience from meditation as a beginner, but it's pretty typical to start experiencing various energy phenomena after a few days. It depends what kind of meditation you're doing though.