The God of the Old Testament was Jehovah, who came to earth as Jesus Christ. He had a spirit body during the Old Testament times, but not a physical body (until after he was born). Therefore, He normally did not appear in a physical form. He was and is full of light.

I wonder if cannabis imitates a spiritual affect, maybe by moving people a little bit out of the physical world temporarily.

We still use holy anointing oil. It is pure olive oil which has been blessed to sanctify it, and is used for priesthood blessings.

(Speaking here of my own beliefs, of course).