I just tried to have taggable behavior for an yii/redis/activerecord, but it was clear that it won't work since yii/redis/activerecord does not support viaTable() in queries.
I believe its reasonable to use in-memory databases to implement some features that have m2m relations. Taggable behavior is a good case, since it is a m2m relation, data values are short and also searching for tags is a frequent operation throughout application lifetime.
This will make a huge improvement in application performance, so why not to make it compatible with noSQL?