If it's just a simple colonoscopy, you shouldn't need home care afterwards; just a ride to and from the doctor's. About an hour after the procedure, your memory should be working normally again, and you should feel fine. You'll be very hungry, though.
They'll probably suggest that you don't drive or pilot an airline for the rest of the day because the anesthesia may leave you a little loopy. Other than that, though, you'll probably feel very normal.