Well there is Weird Al Yankovich, also They Might Be Giants and to a lesser extent Barenaked Ladies. Try also Moxie Fruvous (their Green Eggs and Ham Rap is killer!). There's a lot more that's not coming to mind. The novelty song isn't dead -- but it has gone sorta underground.

Alex