I think I've only ever seen "do you see" used ironically, as in either "Look what an obvious comment I made, I do know it's obvious" or "Possibly that was _too_ subtle, so I'll mock myself". So sort of smug, but not actually superior in those cases.