Other World Computing sells RAM upgrades up to 16GB for MacBook Pro models. Lots of people are using MBPs with 16GB RAM. The main impediment has been the difference in cost between 8GB and 16GB. RAM prices have been coming down, but many people have had problems with certain brands of RAM being sold at a discount.
People who are interested in finding the best deal on RAM that will work in MBPs should check out the Macrumors.com forums. Otherwise, stick with OWC if you want to be certain that the RAM will work in your Mac.
Another thing to think about if you are considering a MacBook Air is the display. A lot of people have problems with LED backlit displays and MBA displays in particular. Eyestrain and headaches may be due to the backlighting, the high resolution or both.
I was ready to purchase an 11" MBA. I spent 1.5 hours working with it. Within 15 minutes I developed a splitting headache and I suffered from severe eyestrain for over 8 hours after I quit using the computer. Needless to say, the 11" MBA is no longer an option. I haven't tried a 13" MBA so I don't know if it would affect me the same way. My early 2011 13" MBP also caused me some problems at first, but the symptoms weren't as bad and I was able to mitigate most of the problem via calibration adjustments.
There is a thread on the Apple forums regarding user problems with Apple displays dating from late 2008, when Apple switched to different LED displays. There are currently 269 posts in the thread. My early 2008 15" MBP also had an LED display and it never caused me any problems. From what I have read it isn't necessarily all LED backlit displays that cause problems, just certain displays. When I purchased a new external LCD display in December I purchased a CCFL backlit display because I did not want to risk having problems with an LED display.
Eye strain from LED backlighting in MacBook Pro:
https://discussions.apple.com/thread/1677617?start=0&tstart=0