For most small projects, C# in Unity is mostly scripting rather than coding. You aren't writing any new methods, you're usually just using the scripting api to figure out which method to use and how to use it. Most of your coding will occur in your Scene Manager, assuming you even need one for what you're making.
Also, not all computer science degrees are useless. Depends on where you go. Mine won't even accept you into the major unless you complete a 300 level (read as: upper level mandatory) course that you won't pass unless you understand object-oriented programming.
That being said, computer science is for chumps. Do a little bit more work under software engineering and make 20k+ more a year out the gate. Laugh as the code monkeys from comp sci become your underlings after a year.