^^^Like Artychik said.
ECT gets a bad rap and has a HUGE stigma surrounding it, due to it's barbaric approach back in the 30's and 40's. I did I project on this so I've done a bit of research...There have been a lot of advancements as of late. You're not conscious for the procedure, and it's (frankly) a lot safer compared to what it was.
I suggest listening to this interview with Charles H. Kellner:
http://psychcast.mblcommunications.com/archives.html
(From the website):
Dr. Kellner is professor and chair of the Department of Psychiatry, and assistant dean for clinical research at the University of Medicine and Dentistry of New Jersey in Newark. He is also co-director of the electroconvulsive therapy (ECT) service at The University Hospital in Newark with George Petrides, MD, and was editor of The Journal of ECT
from 1994–2004. Dr. Kellner’s ongoing research includes studies comparing different ECT types and methods for optimizing maintenance ECT.
You could find current articles at Psychiatric Times and American Journal of Psychiatry that would paint you a more realistic picture of the procedure as well.
I hope I could be of some help.
Edit: Please don't think you are "crazy" because this procedure was suggested to you. It's most commonly used for "treatment resistant" depression - IE, one just doesn't respond well to medication or psychotherapy. Ask your doctor for proper resources, and tell him/her you want to be fully informed before you have the procedure (if at all.) Good luck, and let us know how things go.