Thanks SC, but it was more like the type of transformations below...and excitedly enough after working through a few issues, I was able to create the SQL CLR UDF and it actually works and decrypts the data when passing the field from the query into it.
I appreciate everyone's feedback and help!
// Strip HMAC off!
var cypherText = stringToDecrypt.Substring(64, stringToDecrypt.Length - 64);
var encodedCypherText = Convert.FromBase64String(cypherText);
//Peel the Salt off the front of the String so we can Decrypt
var stringToDecodeEncoded = Convert.FromBase64String(Convert.ToBase64String(encodedCypherText));
var stringToDecodeFormed = TakeLastAaron(stringToDecodeEncoded, stringToDecodeEncoded.Length - 16).ToArray();
// Decrypt the string and then return it!
return Encoding.UTF8.GetString(cipher.TransformFinalBlock(stringToDecodeFormed, 0, stringToDecodeFormed.Length));