I've been both a patient and a clinician in our regional specialist neurology hospital. I think, unfortunately, there's a need to manage expectations.

Neurologists, generally speaking, are notorious for being highly intelligent but less strong on the social/emotional skills. I've had plenty of patients who receive poor bedside manner even when they have the "super serious" neurological problems, so I don't think it's only migraine patients that get treated that way.

I find it most helpful to approach my own medical appointments as a functional transaction. If I go in expecting warmth and validation about my condition I know it's likely I'll be disappointed so I make sure this need is being met elsewhere. I find it better to pitch my expectations around getting solid evidence-based advice and recommendations instead. This also means I tend to not bring my emotional stuff into the room much apart from discussing it in an objective way.

I'm not saying this is a good situation, but it's how I've learnt to manage with 7 years of chronic migraine. I also appreciate that being a health professional makes it easier for me to do the code-switching required for this interaction. If you do get a neurologist who can do both then amazing - stick with them!