DeMarcus Cousins said that finally making his debut for the Golden State Warriors was one of the best days of his life