I've seen a lot, ranging from meh, to looking actually really good.
In an older thread I showed you a hack called Mario is Missing Done Right, so now here's New Super Mario World 1: The Twelve Magic Orbs.
From what I've seen so far this one's quite impressive. Even having custom made backgrounds and some original enemies. :)
What are some good Super Mario World hacks that you know of?