I used to think as many people here seem to. I was trying to pump water from the basement to my tank on the first floor for top-off. I didn't need a lot of flow for this, so figured if I was close to max head, that was actually okay. I pulled 70 feet of 3/4" diameter reinforced tubing (non-kinking sort) through the wall, over the ceiling (most of the length of the run was horizontal), to the tank and turned on the pump. Nothing came out. I could clearly see water making it a little past the point where the hose started heading upwards through the floor. So, figuring I could get just a little more (hopefully enough) by going with a smaller diameter and lowering the weight of the water in the pipe, I pulled all that out and replaced it with silicone airline tubing. The water went almost, but not quite, as high up and stopped.
My wife is a Chemical Engineer... Unfortunately, I didn't consult her until AFTER I had gone through all this effort. She knew it wouldn't work, and she knew the water wouldn't go as high with the smaller diameter tubing.
Just because something seems like it ought to be right intuitively doesn't mean it will work that way in the real world.
BTW - she also mentioned that changing the pipe diameter abruptly (as opposed to a smooth gradual transition) can cause a pressure drop and decrease the head by introducing turbulence, whether you're going from smaller to larger or vice versa. (Again, nothing to do with the weight of the water in the pipe.)
As for my top-off: since neither worked, I left the airline in and replaced the pump with a really high head model (and fabricated a part to take the water from the outlet to the airline tubing - no parts available for that off the shelf).
