See Merge products / variants into one database table (one view / one list), not really a proposal only to start the discussion which derailed quickly. We must first define what a ‘variant’ is and how it should behave.
Variants should be REAL products so no need to handle things separately. Mostly the specifications of the product changes (color, texture, sizes etc), the price and name? It’s the big question how to put that data in.