I think for a first timer trip, I would suggest a resort on the skyliner. This gives you two transportation options between parks, and there are also resorts in all 3 categories on the skyliner.
Value - Pop Century and Art of Animation options. At Pop Century, I would say any room category there is fine. Preferred will put you in the areas closest to the food court, main pool and skyliner stop. But the walk from the other rooms really aren't that bad. Pop Century also recently came out of an expansive renovation and all of their rooms have been refurbed. At Art of Animation, the pricing is tricky. They will show first a cheaper room rate, closer to that of Pop, but those are for The Little Mermaid rooms which are subpar to the newly renovated Pop rooms. If you did Art of Animation, you may be paying deluxe prices for their suites. Suite are great for families, as there are two separate rooms with two full bathrooms. Since you have a pre-teen, this may be good for your family
Moderate - Caribbean Beach Resort. There are a lot of room options at this resort, and unless your 11yo is a huge pirate fan, I would avoid the pirate rooms at all costs. They are far from all amenities and a long walk. I would suggest either a preferred room (close to the pool & check-in area where all food and shopping is), or if you can request a room in Jamaica (close to the skyliner station). Caribbean Beach is also very close walking distance to Riviera resort (all on the same lake, and walking paths connecting the resorts), so you could enjoy the dining and amenities that Riviera has to offer also.
Deluxe - Riviera Resort. I personally don't have any experience at this resort, but I have heard nothing but great things! It is a DVC only resort, so the rooms can be booked either directly through Disney paying cash, or you can rent your stay through someone who owns DVC or through a broker. There are some risks associated with that, so just do your homework! The resort can get pretty expensive if you book cash, so renting DVC may save you money. With it being a DVC resort, you can book suites with multiple rooms and full kitchens etc. I would suggest either a Standard Studio or 1Br for your family - a one bedroom is nice and will give you a similar vibe that an Art of Animation suite as your child will have a separate space from you & your partner.
I would personally choose either Pop Century or Caribbean Beach Resort.