Sound Fx are just another tool in the armoury of a song producer. They can be used to great effect as per "riders" or be completely naff and OTT as per many pop songs. There are many examples of both. Naff CHEESY rap or RnB records often start with a scratchy track or a phony phone call. Then of course there is the 1812 overture.