It is sad that your question is answered by some of those things.
I finally came back to macs after 14 years of just Windows although I still have about 18 windows machines in my company.
I bought two of them in October, and so far love them. Except for Excel, that is supposed to get fixed before Xmas.
I use the Mac Book Pro, 15 inch, 2.66 Intel core duo with 4 GB ram. it is much better than the PC's., I've redone my sites, and can connect and run almost anything on the other computers, the windows server, etc.
I bought the AIR for my wife. she loves it for it's light weight. The lack of a cd is no issue because the mine can burn from hers. The air does not have the card reader, but I have a reader for different types of cards anyway.
I also bought one of the regular 13" ones for my daughter. My son has two 15" and a 17".
Both mine have excellent video chat, battery life, etc.
My PRO is much faster and the track pad is much nicer than the air. I like the AIR in bed or to just grab and check something.
I don't know where a temperature issue is. The temp is monitored on the top of the screen. On a 95 degree day when I'm running something real intensive, it gets up into the 60's (celsius)(maybe it was 70's) then it slows down until the temp gets down a few degrees.
I use a Time Capsule as a router, so it automatically backs up everything whenever I'm home.
Although the AIR is much lighter, The PRO is lighter than any windows machines this size, and I find it powerful enough to run heavy spread sheets. I'm not sure what would require taking another machine anywhere. This is my work computer.