From my understanding, the letters behind the degree can be different based on the school. When people talk about a Bachelor's in Business Administration being useless, they're talking about not really picking a concentration, going with general business which is a is taking classes across the different concentrations instead of Accounting, Finance, or Marketing. When someone says they have a degree in Finance, they really mean they have a BS/BA in Business Administration or BBA with a concentration in Finance, but Bachelor's in Finance is shorter and easier to say.
In your 1st 2 years, you'll most likely have to take Intro to Financial Accounting, Managerial Accounting, Macroeconomics, and Microeconomics. You'll likely have a Calculus class and at least one Statistics class in there too. After you take those, you'd apply to the school of business. Keep your grades up because they have GPA requirements for getting in. I'd think all business programs have a business core that all business majors are required to take whether the letters are BBA, BS, or BA. Those courses are intro courses to all different areas of business such as Finance, Marketing, Management Information Systems. and HR Management. You'll also have your concentration which would be the 3 I mentioned above, Management, HR Management, MIS, and sometimes Supply Chain or Operations Management. There's also General Business which is, like people say, worthless.