No, it’s not worth it this late in the game. If you were a Freshman, Sophomore etc the answer would be very different. In any case, no counselor can help you jump into a place for which you don’t have the mean qualifications. They CAN help you package your application assuming you had all the numbers ( GPA, testing, EC’s) to make it appear in the best light possible.
Given the number of candidates who apply to the top schools who have all the numbers, this is a needed service for some. Does it work? Unlikely IMO, unless the candidate and their parent really has no idea how things work. In that case, yes polishing essays and pinpointing areas of interest might be worth the investment.