I majored in neuroscience in college and I'd say it's better than biology and chemistry, but then I might be slightly biased
I'd also say it's much more interesting than the other sciences; the brain is, after all, really the only piece of matter in the universe that actually does things on its own accord. It's also far more complicated than anything else in science.
Anyway, med schools don't really care. I know most of my classmates were only neuroscience majors because they had this idea stuck in their heads that med schools want "different" applicants and that neuroscience would help differentiate them from the legions of biology majors (which I always thought was pretty silly considering neuroscience is just a sub-field of biology for the most part; if your goal is to be different you'd be better off majoring in art history).
Also, neuroscience isn't the same thing as neurology or neurosurgery. Neuroscience is, as the name implies, a scientific discipline, not a medical one. Obviously its findings are what create the basis of neurology, neurosurgery, and psychiatry, but that isn't what the field primarily concerns itself with.
Anyway, no, medical schools aren't going to care that you were a neuroscience major in undergrad and then become a dermatologist or something. The important thing is to major in something you actually care about. Trust me, you'll do a lot better in classes when you actually care about what's going on as opposed to only taking them because "med schools will like this, right? Right?"
In fact, I'd suggest that you pick your major based on the idea that med school doesn't exist and that it is thus impossible to become a doctor. This is in part because this will let you pick a major you'll be happy with, and in part it's because the depressing reality is that the vast majority of students who start out as pre-med don't ever make it to medical school (so make sure to have a back-up career, because science degrees are only good for getting you into grad school or med school).