my slightly biased opinion of profitablity:
early bankroll building stages (25NL or below) : low stakes ring ~ low stakes sngs
middle stages: midstakes ring > sngs
as you get better at tournaments: mid range buyin mtts > or ~ mid stakes ring
late stages: 1000nl+ >>>> any sort of tournaments

note I play almost exclusively ring