I found something interesting the other day.
We read in 1 Ne 1:6 that Lehi had seen a pillar of fire on a rock. Via the pillar, he saw and heard many things. The experience, however, appeared to be physically draining because in the following verse, as soon as he got home, he went to bed.
In JS-H 1:20, we read that after Jesus and God visited Joseph Smith, Joseph lost all his strength. Even after he was able to make it home, he still needed to lean on the fireplace for support.
Granted, these are just two of the many prophets mentioned in the scriptures, but it does seem interesting that both had visions and both ended up being physically drained. I wonder if this is a common occurrence among prophets when they have their first vision.