Is it worth the trouble to avoid using the SqlParameterCollection.AddWithValue method?

Several articles tells you that you should avoid using AddWithValue method because it can lead to poor execution plans and performance. Should I go through my DAL and change all parameters to specify the SqlDbType? Is it worth the loss in maintainability? (If I change a column-type from varchar(50) to varchar(100) I would n开发者_如何转开发eed to change all the places it is used.)