Same experience here with the ocean view. We had 2 "ocean view" rooms that were more accurately pool view with a sliver of the ocean if you crane your neck over the balcony and make a hard left. But, we could see the cruise ships coming in and out of Nawiliwili harbor, so technically I guess it was ocean view.
Resort is sprawling but the grounds are very beautiful. Large pool. We found the pool water to be quite cold but we were there in February. Beach was nice. Resort is within walking distance to some shops and restaurants, nothing too exotic. We did enjoy Dukes right on the property (we have kids, so this was a good choice for us). There was a large koi pond with many fish, birds, etc. and they had daily feeding times so if you have younger children they might enjoy that. There was a piano player in the open air lobby area by the pool during evening hours and that was a nice touch. Hotel has several laundry rooms on-site, which I assume you'll need for a 2 week stay.
Room decor was somewhat "dated Hawaiian" but rooms were clean and a good size.
My kids enjoyed Poipu Beach, which is a quick drive from the Kauai Marriott. It's good for toddlers and teens alike. Great place to snorkel. We were able to whale watch from there and it was a lot of fun. Also enjoyed Puka Dog, which is a hot dog place in Poipu featured on the Travel Channel, if that interests your kids. There's a Roy's in the same shopping center for a finer dining experience.
Parking at the Marriott was not a problem for us, even though there was major construction on the lot while we were there. Our room was situated on the far left of the resort and there was a side parking area convenient to our building.
Resort does some "shows" on the beach at sunset; fire twirlers and history of the islands type things. I don't recall too much water sports activities right there on the Marriott beach but there are many, many activities available all over the island. The resort concierge was very helpful with ideas for activities as well as restaurant suggestions.
Have a great time! We blew a ton of Marriott points here too (over half a million between this and the JW Ihilani on our last trip to Hawaii) but it was well worth it.