EDIT: To my experience I haven't heard of any non flash related video issues on the MBA. That's more in the territory of MBP with its NVIDIA graphics card glitch that seems to be causing glitches / video skips sometimes, among other things.
<raises hand>
I use my MacBook Air every day in a Production Support environment.
At this very moment, I have Excel open (multipage spreadsheet with IP addresses/servers listed), Activity Monitor (for disbelief), Terminal (for Real Work) Firefox (Flashblock on), Entourage (sync enabled with the local datastore for address book contacts and scheduling), and MSN Messenger connecting to our Corporate Chat solution. I have a second monitor, USB internet connection, and Microsoft Wireless Keyboard (USB transceiver). My home folder is encrypted.
Free RAM is still around .75GB, and the machine has 20 GB free when running at normal load during the middle of the day.
Turn on the machine in the morning, and start up all the above listed applications. About 15 minutes later, the machine running near idle, the fan kicks on (and I roll my eyes knowing what state the machine is in)
Please know that it is better than it used to be- the fan used to kick on during boot or shortly thereafter. I attribute the improvement to careful cleaning and re-application of the caked thermal paste.
Basically, the machine, just running at idle, is uncomfortably close to thermal limits. "Who's" thermal limits changes on the various updates, but suffice it to say that a small amount (1/2 minute) of 100%CPU time on EITHER of the cores is enough to push the machine over the edge, into "130% CPU for System process" in Activity Monitor.
Bring up Opera? System goes into "130% System Process" and the mouse jumps around in typical "CPU Overheat mode"
Edit a large e-mail? Bring up a good sized Word document? Start up X? Sometimes, any of those tasks is enough to provoke the laptop into the annoying "overheat" mode.
I've been to Apple. They tell me it's acting... Well, one of the Geniuses said "it is what it is," and believes mine is "better than some he's seen."
I do NOT recommend the MacBook Air for Production Support to the level described above. 8 hours a day of office work is NOT within the realm of usability without having to suffer some of the drawbacks of the platform, and those drawbacks are severe.
I'm not trying to watch videos. I just want to work with a nice little system that I can take home in something smaller than a full sized work laptop bag, but sadly, this computer, though it works for much of what I want it to do, doesn't fail gracefully when at its limit, and makes things like presentations impossible.
That's another thing that'll push things into overheat, and won't happen again. The last time I tried a PowerPoint Presentation our team got a much better understanding of Apple's commitment to usability and functionality.
I've reinstalled the OS, reformatted the drive (80 GB), and got things working as best I can. I don't have CoolBook, and await an Apple solution after having reset the system PRAM, and trying the various "fixes" from them.
The only things I like about the system these days are they keyboard (better than my MacBook Pro- I can't catch my fingers on the edges of the keys when typing quickly, so can't rip keys off), and the strength of the laptop itself- the curved bottom lends a rigidity that the MacBook Pro can't emulate.
If one just wants to use the MacBook Air with Kermit and as a terminal, it's PERFECT and mine has recovered several Solaris/AIX boxes.
Otherwise, it's useful, until it's suddenly, without warning, not. On top of that, it can take a long time for the system to recover from a heat "event."
Some additional applications I use:
Apache Directory Studio (doesn't cause problems)
SoapUI (Java Webstart Application- if the heat hits on startup, this takes a LONG time to open, but is well behaved once open)
Smcclient (Java Webstart Application for Stonesoft firewall Admin- if the heat hits during startup, can take a long, long time to load, but does behave well after opening.)