The measurement of sound is fun and very revealing. Your ears will thank you. I'm glad there's no appreciable difference in pointing at the source or straight up, at least for the RS meter.
For what it's worth, I have always used a tripod, and I've tested speakers every way imaginable. When testing in-room response on stereo speakers, I point the meter between the two from the listening position at ear level.
I have Stereophile's Test CD 3 that works okay in a player, but if you can connect your computer to your system, that is the only way to go. The program I have defaults to 12th octave steps, and you can play sine, square, triangular, sawtooth, impulse, and white and pink noise. I stick with the sine and pink noise as I don't yet understand the significance of the other noises.