Our Doors Are Different: Well, sometimes.  Automatic, yes, just about all of them as at the Imperial level of technology (or, indeed, the modal level for the Associated Worlds) throwing an actuator on there is cheap, and people are carrying things in all hands often enough that it’s handy not to have to set them down to make the door open.  (Of course, most of these aren’t automatic, so much as operated by thinking “open” at them.)  Also, in microgravity, finding leverage may be annoying for much the same reason.

Leaving aside blast doors, vault doors, and other such things with locking mechanisms designed to survive someone letting off a nuke just outside, etc., and the cog-style spacetight doors designed to be openable regardless of pressure differentials, most of the rest of the Different Doors are the gratuitously fancy non-rectangular-and-with-multiple-moving-parts styles that serve no useful purpose whatsoever except for letting architects and interior designers show off as much as possible.  Which is to say, they don’t so much serve an out-of-universe desire to show off how cool and sciency and futuristic everything is, as an in-universe desire for… well, that.

Special note here to the really fancy swarm-doors made of large numbers of nanomachines pretending to be a wall that essentially melt away to create an opening, or even around you to create the effect that you just melted right through the wall, leaving it intact behind you.  Very expensive, but damn shiny-looking.

And, of course, to the biotech heart-valve or sphincter-based doors.