This sort of thing used to bother me, it really doesn't anymore. Why is that? Well, because the minute I see a single-player game requiring a permanent connection, well that game may as well not exist for me, it just leaves my brain and the possibility of buying it just disappears completely.
My curiosity for the trend in general is for 5+ years down the road. I mean, I still regularly play games from the mid 90s... when its the year 2025 and no one plays this simcity game anymore, will there still be a server to connect to? And if not, I really hope EA and those like them have the brainpower to realize that releasing a version that doesn't require said server for a bargain basement price is still good business seeing as it won't make a dime without the server.
EDIT: Just looked over a page of the best selling pc games of all time by copies sold. I realize you can't draw conclusions about an industry based on one game, but my god, how in the world has Minecraft sold that many copies? It has no real DRM (at least, not in the sense we tend to understand the term), so if DRM is the only thing keeping pirates from ruining everything, how is it the 8th best selling game of all time?