Any degree, it doesn't really matter as long as you have the qualifications. Thats for most regionals. You don't even really need a degree to fly at a lot of places but if you ever want to play in the big boy sandbox you will need the credentials. I'm working on a business degree. Does it have an ounce to do with flying an airplane? No.
The only time you really need an aviation degree I would think is if you wanted to be a test pilot of sorts (Aerospace Engineering Degree) or manage an aviation business or airline or something (Airport Management).
It is usually advisable to stay away from getting any sort of aviation degree when being a pilot. If you ever get furloughed or decide to leave the profession (a very real possibility) then it helps to have something to fall back on. And an aviation degree won't get you very far in most circles outside of aviation.