What is the experience like of getting surgery to get rid of a sebaceous cyst?

Should be routine. Thanks for your question. If the cyst is a less than an inch wide, you are in good health, and you are with a good doctor--it should be routine surgery with minimal discomfort.
Minimal discomfort. Assuming 1]this is of the skin, 2]cometent surgeon] 3] reasonable patient: the procedure is commonly done under local anesthesia, as an out patient. The experience should e less trying than dental work.