Planetside is an example of this. The game is good... has a following...but never sold millions...(it's on PC so the communoty is maybe different).
I'm not convinced consoles can have the same type of dedicated players... though i'm not very live or PSN myself so...
OoOoOoOoOoOoOoOoOoOoOoOoOoOoOoOoOoOoOoOoOoOoOoO