Three games that would get pretty close to that are cavestory (but not many optional subquests), secret of mana (not sure though for the rule #8 it's been a whi

Three games that would get pretty close to that are cavestory (but not many optional subquests), secret of mana (not sure though for the rule #8 it's been a while) and little big adventure (but it's been a long time I've played it so I'm not 100% sure anymore). Incidentally, those are some of my favorite games... But indeed there are very few games that meet all those requirements which is a bit of a pity...