You can tell steam not to update your games automatically (library -> right-click on rebellion -> properties -> updates -> do not keep this game up to date), protecting your safegames if you want to finish the games.
As for the offline problem of yours... I don't have that. If I don't have an internet connection on my notebook I can just start offline mode without trouble. Did you register your computer with steamguard (settings -> account -> manage SteamGuard account security)? I think this is an requirement.
I know it's not nice all those additional features in Steam are automatically activated, as not everyone wants to use them. Steam also provides minimal information as to how they can be deactivated if you don't want them. Still, you can deactivate them, which is what counts to me.
I would interpret the swap to steam as an attempt to reach a larger audience. Steam has a large playerbase and they might get new customers there that never knew about Sins before. The social and chat component can also be quite powerful if correctly implemented into the game (cloud saving for the win).
I don't see it as personal attack. I'm not a Steam fanboy, I know about many of it's weaknesses as I have experienced them firsthand. I personally have had more positive experience with it than negative, but if you don't like them that is your choice and I can respect it (doesn't mean I cannot try to argue against it
).
(Personally I have quite the dear hate for EA and Origin, even though some people hold them in high regard. Doesn't mean I have to accept how the butchered C&C
)