Hi and welcome to EB! :-)
To make it short, I like it. It has a classic look, it fits with the current scale, it uses parts from existing sets and it's a straight-forward build without fancy SNOT technique except for the front. You also thought about the little "ramp" to support the front wheels of the towed car (at least that's what I'm guessing it is). I like the round transparent-white lights, too. Makes it not too modern looking.
I agree, the red doesn't fit in the front but I guessed it's just temporary. And maybe the back could be less yellow and more gray, but the design is ok.
*y*
Oh, yeah, doors would also be nice but that's a current design problem with City sets ;-)