My husband has had many CT's. It's a big xray machine. You lie on the table and they scan you. He had one done last week. The contrast dye isn't too bad, just a clear liquid that you drink. Sometimes they flavor it.
I think in the grand scheme of things, not too bad, non invasive, and not painful, so don't stress too much.