(Besides, the compilers do a good deal of optimization for each platform).
The compilers do a pretty good job of optimization, but I honestly don't know if they do any automatic optimzation for the Altivec or SSE engines.
After all, "pros" aren't supposed to rely on notebooks or iMacs, right?
There's where your premise goes awry. The MacBook Pro has Pro in it's name for a reason. It's meant to be a portable workstation for "pro" users.
With that said, I wasn't aware of the Apple Accelerate framework since my programming is at a higher level than that. With an extra layer of abstraction built in, it means that the developers only have to code against the Accelerate libraries and trust Apple to do the right thing with optimizations. There will be some hand-coded SSE and Altivec code, certainly, but hopefully it will be far less than I had originally assumed.