It depends on the path you take, and even then it can vary from one char to another, even within the same cabal.

I find that you get as much RP out of people as you care to put in, for the most part. There will always be the guys who are just there to PK you, take shinies, and move on to the next. Heck that's even a valid role. But there will be others who will kill you and call on you to doubt your beliefs and whatnot.

And of course the RP between allies is quite a bit deeper than all of that. Again depending on the cabal and type of character, you can go from allied buddy-buddy beer-swilling comrades-in-arms to carrying out a full life with someone you marry, IC.

If you're thinking that you want more in-depth RP, storytelling, lots of emoting and such, I'd suggest you try a Herald of the Eternal Star-type character first. Even if you don't get inducted, you can still sit in (relative) safety at the Inn and interact with Heralds and all sorts of adventurers who come in for a bit of RP.

Welcome and hope you enjoy your stay here at CF! Don't take it personally if you get PK'd! :)