The library is a good option. I have gotten books about RV adventures. About real RVer's (and some not real) that tell about their life on the road. They do give you some idea of things that can happen on the road and how people handle those situations. One that was fiction but a very good story is "The Leisure Seeker".
The two books that Lopo recommended are good too. Covers a lot of what you need to know and do to get ready for RVing and explains the plumbing/electrical/mechanical stuff (which still confuses me
).
One I just read is "Millennium Road" about a woman who takes off in a small RV to explore the country. It is a true story and is interesting to read.
Blogs are another good way to find out what RVing is like, but like Judy said, everyone has a different experience and a different perspective. But I still find it fun to read about it, at least until I am out there having my own adventures!
Check the "Books" thread and search "RV" and see what books come up there.