It can be fun in small doses except when it wants you to watch a bunch of cutscenes instead of doing stuff. The biggest drawback is just the length of the game. If you played 5 hours per week it might take upwards of half a year to finish a playthrough.

That being said, it's probably one of the best RPGs I've ever played and the best D&D computer game I've ever played. I'm fifty so that encompasses a lot of games. The range of morality and meaningful choices is extremely high. To the point where I want to experience making different choices but it's hard because it's such a time commitment to do a whole playthrough just to see what unique dialog options you get for playing a Tiefling or a Druid.

The romances and dialogs can be a little spicy, and it runs the gamut of adult language. I think nudity can be turned off and romance is optional, but you'd have to judge whether that would be a problem for their family. Even the full on sex scenes imply more than they show, but I'd be uncomfortable if I was surprised by one while playing with my kid. This is definitely a judgment call on your part.

It's a great game and I wouldn't want to discourage anyone from buying/playing it, but I'd be remiss to not mention some of the reasons it might not be for everyone. I'm hopeful it might lead to introducing my kids to tabletop play. But I'm not overly concerned with language or adult themes in an appropriate context.