It's right there: Requires Internet Connection and Free Steam Account to Play. It's on the back of the box.
It's not like Bethesda tricked you or anything.
No they didn't lie. But requiring Steam to play was a bad move from them to begin with. I don't play on PC often, but I seriously don't understand why most PC players seem fine with giving up a degree of their freedom.
I wouldn't hate a house because the front gate is ugly.
Perhaps not. But if I were you, I'd buy the house and rip the gate out the very day the papers are signed.