In addition to the above suggestions, which are great, I’d also suggest really looking at how the entire signal flow works in Cubase so you understand where the volume automation really fits in with everything else.
You have several ways to deal with gain staging, basic clip gain, and automation, etc., and how that all relates (or doesn’t relate) to what is fed into your fx chain, etc. For example, it might be better in some cases to use pre-gain so it hits your compressors the way you want, and so forth. Pre-gain and clip gain are independent of volume automation.
Anyway, it’s a big topic, but do searches for tutorials on the above different ways of dealing with gain and fader automation, and you’ll become a master of the signal flow in Cubase, and your mixes will improve.
BTW on top of all that, you can use other tricks in Cubase, like DOP (Direct Offline Processing), which may (or may not) be appropriate in some situations too!
So Cubase lets you deal with this in many ways, just learn the full signal flow and you’ll thank yourself for spending the time.
Good luck!
EDIT: BTW, here’s a basic overview that covers the main signal flow points you should know… it actually doesn’t directly cover using an FX to adjust volume (which is one of the useful suggestions above), but you’ll see where that would fit in the signal flow, and it doesn’t cover VCA tracks (another suggestion above), and it doesn’t cover other tricks like DOP… but it does touch on group channels…
Anyway, so check this one out for starters:
Then, to understand VCA vs groups, check out this:
There are more nuances, but that should give you a good birds eye view.