Hmmm...The transit Sun squares natal Venus twice a year. In my case, it falls in late March and September each year. In my hundred plus experiences with it, nothing much stands out.
The opposition, on the other hand, stands out quite a bit. In addition to the opp nVenus, it conjuncts my south node. It's a time where I gather with family, enjoy food, exchange gifts, observe traditions, and remember times past.
The sun opposes my Venus each year on December 24th, Christmas Eve.