"I want something like SMB3. <links to Super Metroid>"
If you just want a quick scrolling section that does nothing else (like the linked video), that's not TOO difficult. Though if you're talking 8-way free-form scrolling like most SNES platformers and most of SMB3, that'll be significantly more difficult.
Either way you'll undoubtedly have to write entirely new drawing routines. In the case of the quick-scroll, all your new code can probably be localized to just that one effect without having to touch the main game code much, if even at all.
Which MM game is this for?
And are you just looking for advice, or are you trying to recruit someone?