You are correct, the experience is seamless.
Your iPhone will automatically connect (or ask to connect) to any wifi connections that are in range. If one is not available, then it will switch over to 3G or EDGE. 3G is pretty fast in Charlotte, NC where I live, so fast that the difference between 3G and wifi is pretty small if I have good reception.