I think there is a significant psychological effect of having a heavier bike. With a lighter bike, you push the pedals and you can feel the bike exerting more force on your behind. The overall effect is probably not all that significant as far as power output goes. I know that when I had a really light bike, the only place I could really feel the difference was standing up accelerating in a sprint.