Was this a stupid thing to do? Leaving a CSU to go to a CC for 6 years for a chance at a UC?

Why do you need someone to question your choices? Everyone decides on their own path in life and many times things do not work out as planned. You learn from your mistakes and move forward, that is part of being human.