There is a lot of complicated effects that can be done with the stock N64 microcode. Of course, the possibilities are endless with custom microcode, but the amount of people who will be using it is tiny. This manual does not cover how to use the Color Combiner nor the Blender chips in the RDP.
If you wish to learn more, then it is highly recommend that you read the following sections of the N64 Programming Manual: