From a Biblical perspective, as long as God is being praised and no one is playing for themselves, then it really doesn't matter.

From a "musical" perspective I think it will vary from church to church like others have already said.
Basically, there will always need to be some one to keep the time, play the medley, ad lib, and the combinations of making it happen are endless.
If I had to catagorize my style, I would say I tend to play a little over the top. Now that's not saying that every song I play is going to be filled with 70mph riffs and more grease than a bucket of KFC but I guess I just tend to hear more "opportunites" to fill the void.
At church, our music minister/organ player knows how I play and I'm grateful that he gives me the freedom to worship through my bass without thinking that I'm trying to "steal the show". The other bass player at church tends to stay in the pocet more but people are starting to notice that we are picking up tips and ques from listening to each other play (which is great IMO lol).
The important thing is that if:
a) God is being praised.
b) You're giving back to Him what He's given to you
and
c) You're learning and having fun
Then it really doesn't matter who's doing what. Just do the dern thang

God Bless,
-J