The spell needs to target exactly one creature in order for twin to work...
... but there are caveats.
As you've noted, the Twinned Spell metamagic option begins its description with:
When you cast a spell that targets only one creature...
A 2015 errata to the PHB added this note to the description of the Twinned Spell metamagic option:
To be eligible for Twinned Spell, a spell must be incapable of targeting more than one creature at the spell’s current level.
This means that a spell like Chaos Bolt, though it does initially target only one creature, is ineligible to be twinned because it can target more than one creature.
Further, as you point out, spells - like Fireball - that instead target points in space are also ineligible to be twinned. (More on Fireball later)
Nystul's Magic Aura, on the other hand, can only target one creature, but it can also target an object, and that's where the complication comes from.
According to this question about the Heat Metal spell, spells that target objects are ineligible to be twinned. Particularly because objects are not creatures, and the Twinned Spell metamagic option explicitly makes mention of "creature" and not "object."
This leaves us in an interesting predicament, as Nystul's Magic Aura fulfills the requirement of only being capable of targeting one creature, but also that it can instead target an object.
This DM would interpret that to mean that if you target a creature with Nystul's Magic Aura, you could then twin the spell and choose a new creature to also be affected. However, if you choose an object as your original target, you could not then twin the spell.
A few words on the podcast (and subsequent rules interpretation) you mention:
As of January, 2019, Jeremy Crawford's - or any other staff, for that matter - public statements are no longer considered official rulings. Only the Sage Advice Compendium is considered official as far as rulings go. Many of the past statements regarding rules clarifications have been published in the SAC, but many have also been excluded (or just haven't been published yet). This means we can only rely on what is published in the SAC, and we should throw out all previous rulings in tweets, podcasts, etc.
We can find the 2019 SAC here. I searched for mentions of "target," "Nystul," and "affect." I read through all the occurrences of the aforementioned words. Unless I missed something, the SAC does not currently appear to define anything in regard to spells automatically targeting things they affect. Where there might be exceptions, they seem to be explicitly covered in the description for a given spell. Funny enough, Fireball is one such spell. It initially targets a point in space and then treats the affected creatures like targets (emphasis mine):
Each creature in a ... sphere ... must make a Dexterity saving throw. A target takes 8d6 fire damage...
However, like I mentioned, this is explicitly phrased in the spell description, and not an assumption we make because the spell affected additional things. "Affect" does not automatically translate to "target" unless the rules say it does.
Nystul's Magic Aura targets one creature or object and affects them the way the spell describes (emphasis mine):
The target can be a willing creature or an object...
"The target" in this case is explicitly defined. Later, if another spell targets the same target, Nystul's defines how that other spell behaves. That is the extent of the interaction. We choose Nystul's targets when we cast the spell. We do not suddenly have additional targets when someone else targets our target. Nystul's does not make mention of the other spells becoming targets, so we cannot consider them to be.
Jeremey Crawford's ruling on Dragon's Breath directly contradicts the reasoning of the 2015 PHB errata. Dragon's Breath targets "one willing creature" and that's it. Later, regarding the breath attack, it says (emphasis mine):
Each creature in that area must make a Dexterity saving throw...
Note that unlike Fireball, this spell does not declare the affected creatures to be targets. The fact that the breath attack granted by the spell can affect multiple creatures does not change the fact that the spell only targets one creature. This means that Dragon's Breath is, in fact, an eligible target for the Twinned Spell metamagic option.
The confusion Jeremy Crawford's initial Dragon's Breath ruling caused is a great example of why the decision was made to retcon all rulings from before 2019.