It seems both the MacBook and MacBook Pro are exhibiting this behavior and I wanted to share my research/notes on this with you guys if you are interested.
Issue - Complete System Freeze/Lock-Up
Each time it freezes, I have to hold the power button down for 5 seconds to get any kind of response from the system (no cursor movement, no keyboard response, clock doesn't update, no apple-option-esc, no keyboard brightness adjustment, shutting the computer lid elicits no response, no sleep etc). If audio is playing in the background it is now looping the last half second of it.
Hardware Changes and Notes
• Installed OWC 4.0GB RAM upgrade kit - 2 x 2.0GB SODIMM - specifically for the Macbook Pro (Late 2008)
Attempted Troubleshooting
• First complete system freeze happened shortly after migrating from my old MacBook Pro (1.83MHz) to my new MacBook Pro (Late 2008, 2.4GHz).
• There was a possibility that the issue was related to the RAM upgrade so I ran the Apple Hardware test and the RAM came up as functioning properly (even with the extended test).
• The freezing continued to get worse, with several per day, at random times.
• It could have been software related so I erased the hard drive and clean installed Leopard.
• Manually reinstalled software packages and copied personal data over (music, photos, etc).
• This appeared to fix the issue altogether for a day or so and so I sent in my pre-installed Apple RAM to OWC for their rebate.
• Unfortunately, the freezing returned after the short period of running smoothly.
• Removed all external hardware to test, battery only, but freezing continued.
• Nothing taxing on the system or anything to indicate what might have caused the crash (nothing of note in the console logs).
• About 1 freeze per day but still seemingly at random times.
Temporary Fix
I removed one of the OWC 2GB upgrade sticks and now my system has been stable for 8 days. Currently waiting for my new set from OWC to test. I'm currently stuck with OWC RAM (can't get a refund), but that's another story altogether.
----
[Others having the exact same issue on discussion forums]
MacBook Pro - Random Freezing
http://discussions.apple.com/thread.jspa?threadID=1767718&tstart=0
MacBook Pro - Total Freeze Up
http://discussions.apple.com/thread.jspa?threadID=1790757&tstart=0
MacBook - Unstable after RAM upgrade
http://discussions.apple.com/thread.jspa?threadID=1757875&tstart=0
External forums - MacBook Pro (late 2008) random freezing issue
http://forums.mactalk.com.au/29/61464-macbook-pro-late-2008-random-freezing-issu e.html
External forums - MacBook Pro Unibody Freezing Up
http://forums.macosxhints.com/showthread.php?t=95888
----
Video of crash (exactly the same as mine)
http://vimeo.com/2257488
Video of 2nd crash (exactly the same as mine)
http://vimeo.com/2266769