I have a Wacom Intuos 3 and am running PS CS2. I would like to create an elliptical brush where one of the narrow tips is pointed in the direction of which my pen is leading. At first I thought that this might be done through Pen Tilt, but the brush I've created is a counter-intuitive brush shape, with the fat end pointing in the direction of my Pen Tilt. I'm going to try to attach some captures of the brush-design windows.

My questions:

1. Simply put, how do I do what I'm trying to do?
2. What's the difference between Rotation and Pen Tilt?
3. Is there some way to make the brush cursor rotate and tilt like the applied color will rotate and tilt, so that I can get train my hand better?

They had chained him down to things that are, and had then explained the workings of those things till mystery had gone out of the world....And when he had failed to find [wonder and mystery] in things whose laws are known and measurable, they told him he lacked imagination, and was immature because he preferred dream-illusions to the illusions of our physical creation.
      -- HP Lovecraft, The Silver Key

Here's the Shape Dynamics window. In the final version, I'll have Opacity set to Pen Pressue, and possibly the Airbrush and Smoothing options on.

They had chained him down to things that are, and had then explained the workings of those things till mystery had gone out of the world....And when he had failed to find [wonder and mystery] in things whose laws are known and measurable, they told him he lacked imagination, and was immature because he preferred dream-illusions to the illusions of our physical creation.
      -- HP Lovecraft, The Silver Key

1. have you left-clicked and dragged on that square on your top image (the crosshair with elliptical circle on it with two dots, and arrow pointing down)

that is your pen nib, click and drag on that square to get the arrow to point in the direction you wish to use the brush, useful for caligraphy brushes.

2. i think rotation is to actually rotate the brush as you are using it, so a bit like an electric toothbrush, may give swirly effects, but i haven't tried it. and i think the tilt part is the responsiveness to pressure if using your wacom pen at an angle, again not sure though.

3. see answer to 1)

4. oops there is no question 4!!