 We scrambled to find a TDI Beetle with package 1 options including sunroof, heated seats, and leatherette interior.  My wife drives it about 420 miles a week and is averaging 36-38 mpg in mostly city use.  The car got about 42 mpg hwy the one time we had it on the road at 65 mph with A/C on.  The 6-speed auto transmission can be shifted manually or fully auto.  It shifts smoothly and quietly and the 1.9L turbodiesel spools very efficiently.  The ride is a bit stiff, but it is smooth.  The seats are a bit of a pain to adjust but the controls work well.  Don't expect the luggage room of an SUV, but it is good for groceries and weekenders.  We liked it so much we went out and bought a 2004 manual TDI too!