I have active select in my Adventra and I find it a useless function (I am sure some people will disagree). I have always preferred manual cars, and without the clutch, gear change combination that does provide the feedback and feel of driving old-school style, the tapping undersized paddles is hardly a substitute. I personally can't believe someone wasted their time developing Active Select if they thought it would appeal to people who love to drive manual cars but want the convenience of automatic from time to time.
Now that I have got that off my liver, I will assume the Active Select works the same in an SV6 as it does in my Adventra. I have a button next to my gear selector which is "A/S On/Off". I can turn it on or off while I am driving and don't need to be at a full stop to do so. If I turn A/S on while driving, it changes from whatever gear it is in "Drive" to the manual equivalent "5th gear". If I turn it off while driving then it does the opposite and goes from "5th gear" into "Drive".
Deciding when to shift up or down is more in line with how many rev's you want your motor to do. Over revving or under-revving is never recommended. I was taught the old fashioned way of when to select gears and that was to listen to the motor. If it's revving too hard then time to change gear, if it's under-revving then it's time to change gear. I am sure there are some people on this forum who just died inside thinking, there is no such thing as over-revving
You can lose the paddles when turning corners so you generally have to decide which gear you want to pull out of the corner with before you enter the corner (but while you are slowing down to take the corner), so you do need to get into that habit early. Even in a manual car you shouldn't be changing gears while cornering IMHO.
That's my two cents worth, hopefully anyone with a different view will do so respectfully. Personally I find the A/S a complete waste of time and only ever use it to demonstrate it to people who are interested in it. I am sure some people enjoy it. I certainly wouldn't go out of my way to own a vehicle with it in the hopes that it will provide the manual driving experience though.