Most of the above are patronising, and I suspect would be listened to in cool silence if spoken by a foreigner. In fact most recimitations, as they're mockingly known in Dublin, are not great works.
The Percy French one (with the "says she" refrain in each line) suggested is mocking Queen Victoria. (Percy French was a popular music hall comedian and songwriter of the 1900s.)
The longest-lived classic of the genre is The Night Before Larry Was Stretched, which someone - I think maybe Elvis Costello? - does as a song. This is an 18th-century ballad in thieves' cant, about friends gathering the night before one of their number is hanged. The first mention I know of was by Sidney Owenson, Lady Morgan, in one of her novels, but it's probably older than that.