Theravada Buddhism has a helpful map of consciousness called "The 31 Planes of Existence" which divides existence into three distinct, temporary, samsaric worlds. Your experience seems to fit in the "Fine Material World" somewhere between the 15th and the 21st realms.
https://www.accesstoinsight.org/ptf/...agga/loka.html
As I've mentioned before, Tibetan Buddhism has its own spiritual map of the three bardos (or four if the natural bardo is included) and as with the 31 planes of existence, because each one is a temporary appearance of one's own mind one is counselled not to cling to any of them. As Jesus wisely noted in the Gospel of Thomas, "be a passerby" and as JustASimpleGuy pointed out in his answer above, if we rely on Samadhi to reveal God, we lock God in a cage of Samadhi. The 'spiritual' mind hunts for heavenly experiences hoping again and again 'this one is the one upon which I can rest' until it exhausts itself; herein lies its own brand of wisdom. "The road to excess leads to the palace of wisdom". ~ William Blake
It is worthy to note in light of your contrasting experience of pleasure and pain what is written in the 31 Planes of Existence about the human realm:
Rebirth as a human being is extraordinarily rare. It is also extraordinarily precious, as its unique balance of pleasure and pain facilitates the development of virtue and wisdom to the degree necessary to set one free from the entire cycle of rebirths.
It would seem that concealed in every spiritual experience is wisdom waiting to be revealed.