Is it okay to drive a car rented in Canada into the US?

No, because how are you going to get the car back into Canada unless you want to keep going back, and forth.