I’m gonna have to disagree with the crowd here, the worst thing about the soprano is that most people DON’t start on it and get to it after they have acquired another embouchure. I actually think that starting on a soprano is as good as starting on any saxophone and that moving to other saxes will actually not be as hard as to move from other saxes to soprano.
Having said this, you need a well made soprano. These days there are many relatively inexpensive ones . I am very happy with my Chinese made curved Action Improved Bauhaus Walstein.
In all honesty, if you want a fail proof straight soprano you might want to look for a second hand Yamaha 475 and you couldn’t go wrong.