I've just been asked once, on AA 777 1-2-1 config in J where it was an straight swap from one window seat to another on the opposite side so no problem. Got a gift of F PJs from the crew.
Also made the request myself once when travelling with my partner and got a lovely 'yes no problem'.
I wouldn't dare ask to move to a better seat or agree to move to a worse seat of course!