I appreciate all these suggestions. None of these unfortunately look familiar though.
However I will say that while >>11875687 is obviously wrong since I never had a super famicom, this scene from the game is the closest to what I remember seeing. Main difference is that this is a sidescrolling scene while my memory recalls a top-down scene.