I had my best KOM result when I rode somewhere I had never been before with Strava. There is something to be said about just going out and riding hard without focusing on the segments. I definitely agree it ruins the fun from a ride.
It's a poor craftsman who blames the tools. Strava is just a tool and is only as fun or useful as you make it.
Personally, I've found it a very useful and fun tool. But it requires a lot of self control and discipline not to completely screw up both the fun of riding and the benefit of training to a program.