Last I remember looking into it is the hard 90 degree offset is for wind resistance in open water.
In general, I prefer to unfeather my paddles. (Many good paddles can be adjusted--modula small surface area Greenland paddles.) But there's also an argument that you shouldn't change your paddle orientation so that you can do bracing and other manoeuvres by reflex.
https://www.sportsperformancebulletin.com/wp-content/uploads...
I generally disagree but lots of people with more experience than I have don't.