In Graham's videos ( the ones I have seen ) he is talking about a sweet spot when it comes time to hit the channel & track effects chains ...individually and throughout the whole project ... during both tracking and mixing
In one of his vids where he is using Pro Tools he used an external plug to dial back to around - 10 db ...as per track .
SONAR in the console view has the gain trim which doesn't affect the incoming signal as the OP mentioned , yet I have tried what Graham mentioned once I had gotten my audio into SONAR and I feel there is a lot of merit to his approach of gain staging each and every track in the project with the intent of being able to dial in "the sweet spot"
The sweet spot he is talking about is where you can be able to audition your plugs and determine how they affect your tracks sounds in a much more discerning way ...his approach eliminates the most common fallacy and tricks that our ears like to play on us ..
What is this fallacy ? if it's louder it sounds better ...Right ?
I noticed that he liked to also set his plugs to an equal unity gain volume wise when he was comparing the effected audio to the non effected audio ...
I found that to be very interesting because his approach seemed to open up a whole pallet of subtlety of tones where the plugins were able to go through a full dynamic range as opposed to a plugin that was shouting all the time ... hope that makes sense ...
Interestingly enough I did notice that my Pro Chanel was magically cured of it affliction of always going into the Red once I started using Graham's approach ..
Anyway , as far as the levels of inputting audio and midi into SONAR ..
I have a Focusrite 2i4 and it does offer me a lot of control as to how hot I want to record ...
My general feeling about that is I'm a very dynamic player so I will always leave a little bit of extra head room ..
Recording at 24 bits I like to stay in the green ...my general RMS is Pre Loudness Wars ...
around - 20 db for my peak RMS level and I like to peak overall in and around -6 to around - 4 ...MAX
I have also used a hardware compressor at times for playing that is not meant to be as dynamic...
ex, tracking in Rock and POP where there is meant to be a lot of glue ...
Even then , the compressor going in is not used to squash , it's more there to compensate for the fact that I like to hit it hard on the guitar so by backing off and giving an even level to my live recorded sound where what goes in gets printed ...it has helped catch a few tones I would not be able to get if I stayed totally in the box ..
After having said that , I think I may have gone a little nuts

Why ? who else here is agonizing over every little detail ?...
Fighting for that extra little inch of a db using a pre recording time pep talk ritual just like the Al Pacino locker room speech in the movie On Any Given Sunday ...
What about all the sleepless nights of worrying about how this approach compares to how "fill in the blank " a famous producer does it ...

I got into music to meet pretty girls and now look what recording has done to me ...
I no longer care about what pretty girls in bikinis look like on the warm beach ...I want to look at a computer screen with a New SONAR theme on it ...
In the end , it's Music right ...if it sounds good it must be good
Aye Carrumba so this is how 2017 is starting out for me ? ...I'm in deep $hit
all the best,
Kenny