Ok, Getting onto the Soapbox, so forgive me a little personal opinion.
IMHO, Erotic scenes can convey as much about a character as any other type of scene.
Action scene? You get to know how the character reacts to threats, their mentality on attacks, defense, etc. All of which show past/future of the character, and how they react in a death situation. Someone who has always followed the "Get em before they get you!" mentality is going to be very different in a fight scene than somebody who spends their time concerned about collateral damage.
On the other hand, understanding why characters do certain actions in bed, why they like this move, as opposed to THIS move, also conveys a great deal about the character, and the way that they think. A character who concentrates solely on their own pleasure, or what their partner can bring them is going to be very different in their erotic dialog/content/general attitude than a nervous, quiet virgin. They might not be someone you would want to have a sex scene with, and while the standard in Porn is to completely ignore that and have the scene anyway, you can take your time and figure out a reason that doesn't involve "He's got a big dick... so it's all cool" style stuff... (Of course some folks aren't in the mood for the build up... which Is why I usually helpfully provide links to my sex scenes if they're a bit obtuse to get to.)
Now, do I expect everybody who reads my stuff to give a crap about character motivations, dialog and the like? Of course not. The story has to be a GOOD story before it can be anything else. If the story doesn't entertain, there's no point in seeking higher aspirations. I know full well that my own work is a bit hit or miss for some folks on the good story part. And I make no apologies for my poetry, because it's stuff that I use as source material.
Adding in the Interactive/Game element makes it infinitely harder, IMHO, and Kudos to those who can pull it off.
So, yeah, I think there can be a higher aspiration than just a "Get folks off". Do I think everybody should aim for that ? Hell No! If it ain't fun, don't do it! That's the whole point of writing, IMHO. To have a good time, and to try to entertain and possibly enlighten. I strongly disagree with English professors that only the enlightened critics should judge work. If you like it, and it represents something you want... Who are the critics, the educators, and the politicians to tell you that your taste is bad? If you're smiling, laughing or generally enjoying yourself... you're probably pissing off an authority figure somewhere, so I encourage you to do it!