As a collector, I've had several C-melody horns pass through my hands. They have their strengths and weaknesses. The good news is (as others have said) you can read from a piano/violin score - so long as it's in the C-melody's range. The bad new is that C-melody horns do have a muted, softer sound than others in the family. I've experimented by trying different mouthpieces, but the essential "softness" of the sound is still there. You can make them "wail" but you do have to work hard. Alto & tenor saxes are much punchier and more exuberant by comparison. There are plenty of Youtube videos showing how C-melody horns sound, and this one will give you a good idea:-
I only have one C-melody in my collection - and it's a straight-necked Conn New Wonder Series I from the early 1920s. It has a front-F key (which most others don't) so altissimo is an easy option. I could have more C-melodys if I really wanted - but the point is that I choose not to. I have one - and that's purely to "tick the box" re. my collection. The only way I'd buy another C-melody would be if it were in truly excellent condition at a very silly price.
Of course, there are some people out there who are real aficionados of C-melody horns, and I don't want to rain on their parade. If people have a real love for C-melody saxophones, then who am I to judge? People should play whatever saxophone-type makes them happy. My comments are based on my personal preferences, which might well differ from yours.
C-melody horns tend to be are very "niche" among pro-players i.e. regarded as very much outside the mainstream - and with good reason. Joe Lovano has done a bit of work with a Conn straight-necked C-melody, but he plays mainly tenor as you doubtless know.
My advice is to stick to alto and/or tenor sax for a bit longer, because there's much more potential (and money!) in them. However... if you did happen to spot a C-melody made by Conn, Buescher, King or Martin that's in really good condition at a stupid, give-away price (maybe via some estate sale?) then there'd be no harm in buying it purely to put into storage for the future when you've done more work on alto/tenor. If you do take the plunge and buy one, try to get one with a front-F key e.g. a Conn as already mentioned, or a Buescher Truetone Series 4. If you go for a Conn, try to get one dating from 1925 onwards, because it will be the New Wonder Series II with "nail-file" G# key.
Stephen Howard has some interesting reviews of C-melody saxophones on his website. I agree with his general comments regarding C-melody horns as a type i.e. their sonic characteristics.