Does it matter if i train and pass Cat C in an auto?

As long as your car licence allows you to drive manuals then it doesn’t matter a hoot what type gearbox the Cat C vehicle will have.
Most trucks nowadays are either semi-auto or full auto, manuals are rare and are probably only fitted by special order from customers.