If you are a Canadian citizen, then yes, a Canadian passport will work to enter the U.S. for short trips. However, if you are an American citizen or a dual citizen, then you will need a U.S. passport to enter the country. Having only a Canadian passport will not be enough in that case.