Jasper Carrott’s #5 hit “Funky Moped” mostly sold because of the B-side but it’s still an interesting listen.
Vic Reeves got to #1 with “Dizzy”, but that was a cover version of another artist’s song, so I’m not sure it really counts. It is very enjoyable, though.
Baddiel, Skinner and the Lightning Seeds got to #1 twice withThree Lions, but the Lightning Seeds were a real mainstream band.
For Eddie Murphy I like Whatzupwitu (feat. Michael Jackson) better… Not sure why MJ’s presence wasn’t enough to make this more of a hit, I think it came out a few months before his '93 scandal.
It would have to be one of the early Will Smith songs–possibly I Think I Can Beat Mike Tyson, but several others would be in the running. (This is discounting Weird Al songs, which would beat Will Smith like Mike Tyson.)