When considering Yale, it's important to remember that the department has radically changed over the past 5 years. Previously, the clinical department was unable to attract the most competitive residents to train there. The recent hire (~4 years) of a new chair from Partners (MS, basic science) and the former PD from partners as the current PD/Vice-Chair at Yale (stroke/icu) has led to dramatic growth in the department.
They brought in a lot of money, attendings, and labs. Similarly, the neuro facilities have basically all been upgraded/renovated. The department now is dramatically different than it was even 5 years ago. Clinically, they came with an army of attendings from the Partners program and have continued to aggressively hire and grow the program. For instance, the neuro-ICU has now grown from zero to 4-5 attendings with a number of active trials. Historically, the program has been particularly strong in epilepsy (as well as their NSG colleagues). Other people can speak to particular fellowships of interest, including ICU, neuro-ID, etc.
If you're serious about a research career, you'll be able to take advantage of outstanding research opportunities with program support. They have one of the only fast-track like training pathways in neurology. It's a 5 year program that covers residency, fellowship and 2 years of >80% research time (your fellowship is spread out over 2 years with majority fellowship time).
As noted above, the PD in particular is great--- excellent teacher, incredibly nice, and very easy to work with. The workload on the neuro service is entirely reasonable and is by no means malignant. They have a night float system, for whatever that's worth.
You'll have to determine the fit based on your particular interests, but overall, this is a great training opportunity and deserves a look by all competitive applicants.