See, the problem with the idea of "realism" in Trek is this: To someone from 300 years in the past, we seem to be living in a utopia already. Many fatal diseases have been cured, or at least have treatments. Your chances of being horribly murdered are substantially lower. Even the poor live at a standard of living above what would pass as the upper-middle class at that time. Even among those who are working class, relatively few do back-breaking, physically dangerous labor - and that number continues to drop due to automation.
What hasn't changed of course is human nature. Culture, however, has changed in some ways. We don't look to respond to violence against our families with deadly force any longer - we trust the law to do it for us, for example. But on the whole, people are just as fallible in the 21st century as they were in the 18th. And they will be just as fallible in the 24th century as well.
Thus I think a realistic portrayal of the 24th century would be, by our standards, utopian. Nearly everything we consider "work" today would be done by super-intelligent AI. Crime would be much lower, but perhaps not totally eliminated. People will live longer and healthier lives. Material want may be largely abolished. But people will still (absent significant genetic modification affecting personalities) be pretty much the same as they are today.