Short answer: there is no reliable evidence that psilocybin or LSD can reverse vision loss after venlafaxine. I cannot verify any treatment effect for restoring sight in this scenario.
Before considering psychedelics, it is important to have a thorough eye and neuro-ophthalmic evaluation to rule out medical causes. If no organic cause is found and a functional component is suspected, stress and anxiety might play a role in how symptoms persist.
Some researchers discuss potential links between psychedelics, stress reduction, and neuroplasticity, but this remains unproven for vision recovery. For background on neuroplasticity and psychedelics, see this overview.
If you still choose to explore a psychedelic session, keep expectations modest, prioritize safety and legal considerations, and focus on overall wellbeing rather than vision restoration.
Wishing you clarity and safe next steps.