I just underwent the Caldwell-Luc and here's my take on it.
If you need it, don't research it or you'll chicken out. Other than that it's no big deal. It's painful so you'll get some nice drugs, and you'll have to take antibiotics.