As the question states, aren’t they supposed to reminds us of the Son of God, only judging by some priests I know, they only remind me too much of all the weakness of human beings, big ego, self-importance. Do we see them as magicians of God, speaking sacred words in Latin like a spell, or are they they to remind us of Christ, through example?
Ideally yes, they are supposed to imitate Christ by their example. That said, ordination doesn’t magically make a person holy. we are all imperfect creatures and all need the help of God - priests especially. I don’t think that people’s expectations of priests are wrong - it’s only fair to expect that a person who preaches the word of God and acts in the person of Christ will imitate him and live by the word. At the same time though, recognition of priests’ struggle is important too. In the words of a prayer by St Therese:
I pray for your faithful and fervent priests;
for your unfaithful and tepid priests;
for your priests laboring at home or abroad in distant mission fields.
for your tempted priests;
for your lonely and desolate priests;
For your young priests;
for your dying priests;
for the souls of your priests in Purgatory.
But above all, I recommend to you the priests dearest to me:
the priest who baptized me;
the priests who absolved me from my sins;
the priests at whose Masses I assisted and who gave me Your Body and Blood in Holy Communion;
the priests who taught and instructed me;
all the priests to whom I am indebted in any other way
O Jesus, keep them all close to your heart,
and bless them abundantly in time and in eternity. Amen