Check Apple's Developer Connection site. There is a lot of processor-specific information in there, particuarly with respect to Velocity Engine (vector processing unit) and even some sample code. Motorolla, I believe, also has some technical details posted on their processor lines (white sheets or what have you).
Also, there was a review on ArsTechna recently, but it focused on the G5.
Of course, then there is always Google....