I rode it in 2007 and I remember it not being the most amazing experience. The trail was not very scenic or supported except near major cities/towns. Even then, as others have noted, you need to plan ahead as water could be off, stores/restaurants may not be open on certain days, and so forth.
Here's the first entry from my journal on the Katy Trail -
http://www.crazyguyonabike.com/doc/p..._id=58713&v=3t