It took me a while. Once I was in shape, didn't get horribly sore, could hit impressive PR's, and saw undeniable results. That's when I switched from "ugh gotta go to the gym" to "hell yes time to tear it up at the gym"
I think seeing the massive pattern of progress without dealing with the soreness is what I need to enjoy it.