Riina was used to do the dirty work and that's it.
Indeed although Provenzano didn't object the massacres he was always the more intelligent mafia boss MMD also. So I agree Riina was an idiot, but everybody was afraid of him even his own men. After the murder of Salvo Lima it became a big mess politically also.