Is it dangerous to get a colonoscopy?

No. Risk of perforation and bleeding exist, but is quite low and rare.
Very. Safe and low risk procedure. The risk is not having one and risking an undetected cancer. Most facilities use Propofol now for sedation and you wake up feeling great without a hangover.