The word "nigger" no matter how you use it or in what atmosphere you use it, is a derogatory term. There is absolutely nothing positive about the use of that word.
Black people have turned/tried to turn the word into something positive. It's almost the reverse of how the nazi's turned this