First I would not pick based on dual enrollment vs AP if both fit your schedule etc. I would choose based on which sounds more interesting. Both of my girls took dual enrollment sociology and loved it. In terms of it affecting gpa unless you go to the same college or transfer into a feeder school (cc to same state state school) the gpa is not typically used in college (you get the credits but gpa comes from the classes taken at the school). However once you apply to schools past the bachelor’s level all grades from all colleges including while in high school come into play. While colleges do not guarantee credits ahead of time many have an online transfer link that shows you what has transferred from a specific college in the past (name for that varies) and admissions can help you find it.
My older daughter attends a private school and received credit for her dual enrollment classes. However if the course isn’t needed by the college you go to if you get credit it may be a free elective that you never have use for. I would suggest looking at the individual schools your thinking of to see if they require either intro to psych to sociology (names may vary) towards the major or more likely towards general ed. I know for many schools intro to psych or intro to soc may fulfill the same general ed requirement (and there may be other options).
I would make sure the college class works with your school schedule, read the rules for dual enrollment classes at the schools you are interested in since that is not the same for all schools and make an educated decision based on your interests.