It's called intrusive r. It is quite common, particularly in normal 'fast' speech'. I've been trying to say 'Napa at' without an intrusive r and it sounds like I'm saying 'Napat' if I say it quickly without r! Would you leave a pause between the two words to define the word boundaries? As for 'sore of my dear' I agree, it does sound unpleasant!