Exactly, you can really go to town on your data, get nasty with it:)
I love regex myself, I feel like a ninja using them:) The replacex function was one of the first ones I implemented. Regex_split is the latest one and I love it (the single post on the QueryStorm blog is about that one).
If you're .NET-savvy, check out the "eval" function, you can implement a function as a C#-like lambda expression.
I did a poor job explaining what the plugin can do, QuickQueries is a step in that direction, but I only prepared a few. Plus they need short videos or at least blog posts to go along with them.