@WNYTONY I like your set up.
I agree with @josh lucky 13
Sounds like it would be easier to go through a side wall, ideally in the attic, rather than through clay tile roof.

It might be easiest, although not as refined or aesthetic, to put a fan in an open window, double hung or sash like @Emperor Zurg said would be best so that it doesn’t just suck air in from outside and right back out.

In the set up I am contemplating, it is a basement room with no windows. Up into the ceiling and out the sill is my plan.