Drupal 7 and Open ID
Yes, OpenID always works with an URL, which is your identifier.

I think what you are looking for is the Janrain Engage module: http://drupal.org/project/rpx. This provides a similar workflow and UI like the one you know from StackOverflow.