This is a matter of opinion.
Soap Opera Effect is so called because soap operas were shot at the TV frame rate (let's call it 30 frames per second), many more frames than movies, which are still stuck in the 1920's standard of 24 frames per second. Because soap operas are produced on budgets much below those of movies, smooth motion became associated with low budgets - hence the derogatory term "soap opera effect".
The fact is that 24 fps motion is pretty bad. Film-makers are always faced with its limitations: juddery motion, slow panning shots, long per-frame exposures to disguise the shortcomings. Of course we've got used to these issues over decades of watching movies. But they are issues, and the motion picture industry is gingerly looking into dealing with them. Now that the cost of film stock is not longer a part of the equation ( a major factor in the 1920s) we will see a move to higher frame rates, and old movies will start to look very odd.
I thought the subject of this column was going to be "edge enhancement" or "sharpness", both of which create very ugly pictures.