While there is nothing wrong with the name "Roman Catholic" in and of itself, it is indeed often used in a deragatory fashion by Protestants who emphsize either explicitly or implicilty the "Roman" aspect over the "Catholic". Whereas "Catholic" tends to just mean "Catholic" no matter who is using the word, "Roman Catholic" tends to be used by many Protestants as a synonym for words like "Romish", "Popish" or whatever other term they can come up with that denigrates the Church into some man-made, heretical institution. So, as a general rule, no, we Catholics do not appreciate it when the "Roman" is tacked on to "Catholic", simply for this reason.
Additonally, for whatever it's worth. Using the term "Roman Catholic" to refer to the whole Church isn't entirely correct anyway. The one "Catholic Church" (it's proper name) is actually made up of about 22 different Catholic Churches (Byzantine, Coptic, etc.) throughout the world (that all share the same faith, just using different modes of expression basically), including the largest and best known of them all, the Roman Catholic Church.
Hope this helps.
Greg