Yeah, the question is most likely too broad and more asking for trivia rather than solving an actual problem. Although coming right to my mind are two games from
Enix:
Terranigma has a protagonist fighting with a spear (ok, close to sword), and
Illusion of Gaia (also known as
Illusion of Time) has a flute wielding hero. :) —
Mario 24 mins ago