I can totally relate-- my DS (now 3) woke up 3-6 times a night until he was 27 months-- at which point we weaned completely. It was exhausting and really took its toll on me physically and emotionally-- although I don't know if I would have done anything differently. I tried many times at different stages to break the night-nursing cycle, but DS has always been more stubborn than most kiddos :) When he wanted to nurse, he wouldn't take any other form of comfort and got immediately hysterical if DH tried to soothe him. We tried Jay Gordon's method but it didn't work-- DS was inconsolable...
I slowly began weaning around 26 months and night nursing was the last to go. We had two or three really hard nights, but DS was ready on some level (or maybe I just tell myself that to feel better about it :/ ) DS now sleeps through the night most nights-- usually 8:00-7:00 (11 whole hours!!!!) When he does wake up it's because he needs a drink, or to go pee, or his blanket has fallen off. I feel like a new woman, honestly. But it took me a long time to recover from those two and a half years with interrupted sleep. I'm so glad I did it for DS, but it certainly took its toll on me!
**Please don't read this as me trying to convince you to wean your little one-- I'm not at all!! I just wanted to share my experience. Many other people I've talked to have had great success with Jay Gordon's method, and I would definitely give it a try (I did!!) And I know it may not be any consolation now, when you feel like a sleep-deprived zombie, but this stage will pass. I can't believe that I was nursing DS 6 months ago-- it feels like soooo far in the past.