What is this very special major? It’s very possible that a SUNY does have a major that will get you to your career goal. What IS your career goal?
ETA…I see it’s advertising. I’m quite sure there is some major at some SUNY that will get you to that career goal. @blossom might be a good one to explain how you can get to careers without actually having a major in a specific field.