I moved to a S-A 2 speed hub last year and think it's great. I have a higher high and a lower low than I did on my single speed setup that it replaced. Most of my riding is flattish with some rolling hills. I could see liking a few more gears occasionally, but feel that 2 is adequate. However if going from 1 to 2 speeds is heaven, going from 24 to 2 would probably seem like hell to you.
I am currently building up a commuter with an SA 5 speed hub, though. I guess I will find out what it's like but for now I keep wondering about how I am going to mentally handle all of those choices. Oh, the struggles of a bike commuter!
Good luck.
-G