IMO, playing chamber music is incredible. Not sure I'd use the word "sexy," although plenty of musicians get into that sort of trouble after rehearsal...I personally try to stick to business.
Re finding players: check the ACMP, Association of Chamber Music Players, to get lined up with strings, etc. in your geographic area. It always helps for a pianist to work on repertoire ahead of time, sight-reading the romantic and impressionist works can be tough. I've been studying the Faure and Schumann quintets right now, wonderful works. The string players can sight-read them, but the piano parts require some work. When you do get all the people lined up, though, when you've done your homework and away you go, chamber music is wonderful.
Getting balance right at performances can be tricky; sometime it's best to use the short stick or no stick; also, the size of the audience makes a difference, and the balance between piano and strings can vary with distance from the stage.
Also, don't forget piano four-hands as a form of chamber music. There is much great literature to explore there, too.
Cheers!
Glenn