Go ahead, keep playing the soprano, but it doesn't fit into a marching band or a concert band, and it fits in Jazz band only for rare solos. The soprano will likely be useless in Middle School.
If you need to play melody, go with alto, because you're right, tenor is almost always harmony. I prefer tenor. If everyone played melody, it would be horribly boring.