The one situation where "herein" is somewhat common in spoken english is when describing a situation that should contain all the clues to an answer, but the exact answer isn't clear.
For example,
Herein lies the problem. Followed by a lengthy discussion about the circumstances of the event or events surrounding the the subject which allude the solution when taken as a whole.