Most aesthetic dental procedures are not painful and can be performed with local anesthesia to numb the area. However, some procedures, such as extractions and implant surgery, may require sedation or general anesthesia and may be more uncomfortable.