So now that Druids can wildshape into an Intellect Devourer, Great Old Warlocks with the Pact Of The Chain should have an option to have the Intellect Devourer, Us, as their familiar.
Even if they do, Us still wouldn't be as good as the imp. The imp can fly and so covers far more ground, it can turn invisible at will and so is a sneak attack monster, and it hits harder.
Us just has more hp and would be a better damage soak, other than that, the imp wins. I would still choose the imp every time.
Silly me, I was thinking it would be nice to have a familiar that would fit into roleplaying a GOO Warlock.

It would be nice, not disagreeing there. For me it couldn't just be about role playing though. Us would have to be better than the imp for me to choose him, or at least overtake the imp at higher levels as some others in this thread have suggested.
Right now I can only go by how they are in the game currently, the rest is just speculation.
I'm not dumping on your idea though, I'm just adding to it by saying sure, it would be cool, but then let's make Us unique to the Great Old Ones pact of the chain, and make Us in some way better than the Imp for the incentive to actually use him.
Otherwise it is just a roleplay move, which, at least for me, means I'd never use him.