It's possible and even likely that whatever you've worked on most of your career isn't going to be like that. Most products disappear quickly and few people care if they didn't personally profit while they existed. But the products that do matter and will still exist in a thousand years, will do so because of the technology, not because of the people.
None of that is to say people don't matter. There is no point to creating and using technology if no one ever gets to live a more satisfying life because of it. And one of those people may as well be you. So, by all means, go and find your bliss if you can, but don't believe that organizational effectiveness requires the people in it to be satisfied and happy with what they're doing. Slaves built the pyramids. I'm sure the vast majority of soldiers in the Red Army didn't want to be there and served at the threat of execution, but they nonetheless swept over the Nazis and shaped world history to this day.
As for me personally, I've liked the people everywhere I've ever worked, and the very first software job I ever had remains the most interesting and challenging technology I ever worked on. Every time I left, it was for more money. Ultimately, the life outcomes of every future generation I'm ever responsible for, as well as my own, depend more on socioeconomic status than how much I like my co-workers. They come and go pretty frequently anyway, whether you change companies or not, whereas family is for life. Better relationships with them matter a lot more.