Hi,
Interesting topic this is, have been reading about it myself.
Lots of professionals find the sRGB modes a bit too saturated, the Adobe-RGB reproduces a wider gamut of colours.
When it comes to printing, the sYCC colour space provides better print quality with jpegs.
The Adobe-RGB is in general the better mode
There is big difference in colour modes when you look DSLRs, the sRGB mode isn't always the same. It depends on the software parameters. The difference is the following one; The whole top range of the professional bodies have a more genuine colour reproduction than the none-pro bodies. The none pro bodies have more creative reproduction. The difference is that the creative colour reproduction differs from the memory colour reproduction that the pro bodies produce. But that's all matter of software; parameters. It isn't that much of a problem, or there isn't really anything wrong with the creative colour reproduction. The only thing that can show you a true difference is when you compare portraits. The difference comes clear when it comes to the reproduction of skin colours. They call this memory colour, it are the colours that we are used to see our whole life, the colour reproduction of skin colours are a very sensible thing. It may sound strange but the fact is that when you buy a camera in Asia and another one in Europe/USA, you end up with same body of course but the parameters of the software of the colour reproduction differs.
Shooting RAW and in Adobe-RGB mode gives you the best of both worlds 8)
Cheers