I've been having a good time putting in bass notes by hand and copy/pasting  in Piano view and wondered how to "pull" or bend a note or add vibrato?
Is there a video instruction on the subtler aspects?

I've not seen a video on it, but I work in PRV all of the time and if you're using midi, then the instrument that the midi is triggering needs to have pitch bend assigned to it to get a bend, i.e. unless you're th8inking of doing it with melodyne.
For vibrato some more complex samples have a vibrato layer that can be cross faded to, sometimes using cc:01 mod wheel.
For soft Synths ... Omnisphere for example, is a programmable synth so one can assign an LFO to modulate the fine pitch control to create vibrato. Sometimes one might use a bit of the same modulation to gently raise and lower the volume by assigning that same LFO to amplitude.

Drawing pitch wheel with a virtual pencil is doable and a bit of practice
will show you how to get the right feel of a bend.

I've been doing pencil work in the PRV almost exclusively for the past 6 months.
This whole playlist called "Recent Chronological" ( it loads by default when you go to the page )
every song is penciled in the PRV.
http://www.sightsea.com/music/

Thanks Steve.
I do have a keyboard with a pitch wheel but was trying to do it without an input device. 
I guess that's what you mean by "pencil work"?
I guess I'm avoiding all the confusing setup with the midi input devices. (preference settings etc)
It's just so simple to "pencil" them in with the mouse.
Velocity is simple too so I wondered if I could do a simple pitch and vibrato with the Mouse too.
Where should I look for instructions on penciling in pitch bends?

Yes. No input device other than the mouse.
Look at the controller pane at the bottom of the PRV window.
Now look over to the left under the keyboard for a + sign to add an other controller.
Choose to add "Wheel"
In Sonar 4 Producer I then type an "L" for the line tool and draw the line, or a "D" for the draw / pencil / freehand
tool.
There's a bit of a learning curve, getting used to what shapes produce what results but it's do able.

I'm just demoing X3 this week and it seems now we have to reach up to the edit tool selector,
right click on it, choose "Line" and then move back down to draw.

Hey Cool, That worked. (I'm X1 Producer)
After the + I went up to Edit to choose New Value Type then Wheel.
Then drew with the pencil tool
Thanks Man.

You're welcome. Glad you got it and have a good time!