If this is your dream car then absolutely don't compromise. I was brushed off too. I've never seen a salesman less interested in selling a $40k car. He just messed around for a week saying that he would call me back when he found one with a manual shift. So in the mean time, I found one, drove to Georgia and bought it.
Maybe make it part of your vacation!