So is it possible to turn the effect of completely or just for specific cases?
It should turn it off completely.
In Divine Divinity I avoided the DeathBlow skill because of the screen shake effect; it was a bonus on a sword I found late in the game, but it didn't quite trigger often enough for me to switch back to the previous sword.
