Most patients state the it was completely pain free
We can't promise zero discomfort, but the majority of the time, patients state that the entire process was completely comfortable. Most experienced cosmetic dentists use materials and techniques specifically to reduce discomfort. Anesthetic is almost always used.
Situations are different, and some people have other issues to fix at the same time as a smile makeover (sometimes root canal therapy is done at the same time), but generally speaking there is no pain.