Super elevation (AKA cant...no apostrophe) in the prototype had everything to do with the speed of the train. High speed passenger trains used it to counter act the momentum when it came to a curve (Newtons first law of motion: Every object in a state of uniform motion tends to remain in that state of motion unless an external force is applied to it.). Something going straight wants to keep going straight. If you turn the train then everything IN the train wants to keep going straight (and slide off the table). By super elevating the track it increases the downward force helping things to stay where they currently were. Mainlines with passenger traffic would have a lot of super elevation...branch lines and less traveled routes not so much if any.
At the ends of a curve, the amount of cant cannot change from zero to its maximum immediately. It must change (ramp) gradually in a track transition curve. The length of the transition depends on the maximum allowable speed—the higher the speed, the greater length is required.
For the United States standard maximum unbalanced superelevation of 75 mm (3 in), the formula is:
v_{max}={\sqrt {\frac {E_{a}+3}{0.00066d}}}
Bottom line is in the real world the maximum value of cant (the height of the outer rail above the inner rail) for a standard gauge railway is about 6 in or 5 to 10%.
If you are modelling a well traveled mainline you can have as much as you want (depending on the train speed limits) and probably go more towards the 10% (so it is more noticeable). For N scale this would be about 1mm (9mm rail / 10% = .9mm). Then again, it's your railroad and you can do whatever you want.