Herniated L3 & L4 20 years ago, had surgery 3 years ago. It was great, took about 1 1/2 yrs to fully recover 99.5%
Herniated L5 1 year ago

Had surgery 10 day later. Worst pain I have ever been in, both sciatic nerves where pinched, both legs/feet numb. Could not sit, stand, walk for more than 30 sec. I could NOT even sit on the can to take a sh*t, honestly it was that bad.

3 vicodine 750 mg at one time + 1 Valium + 1 morphine and I could sleep but not walk, stand or sit.
Surgery helped 90%
All depends on your situation.