So in trying to get PyroCMS up and running on Rackspace Cloud Sites I came across an issue with removing index.php from the URL
After much time wasted in tinkering and playing I found the solution, adding in a / before the index.php in line 42 of the .htaccess file solved the issue and my sanity.
RewriteRule ^(.*)$ /index.php?/$1 [L]