The 49ers stadium in Santa Clara has brought nothing but traffic, zero commercial or housing development. The Warriors' Chase Stadium helped vitalize Dogpatch but I guess one could argue that area was naturally going to be built up given UCSF expanded in that location.