Ok, here is the real deal. I have successfully beaten the system here in IL, so don't worry about speculation from others that haven't tried in this state.
First, there is no visual. They will not look for cats, no matter how loud or stinky the car is. They don't care. Nobody even hinted at looking under my WS6, which had headers, ORY, loud catback, and a cam.
Second, whether or not you'll pass with your current tuning all depends on how it was tuned. Since I didn't tune it, there is no way that I can say 100% yes or no. But, I can tell you that all the major local tuners (like Speed, FLP) know how to set this up properly so you can pass. But beware, depending on the tuning software (I did all my stuff with LS1 Edit, I have no experiance with HP Tuners), you can get the SES light off but still not pass the test (based on non-complete DTC test status). Again, if you went to a local big shop, you're probably fine. Worst case, if you have more than 2 tests showing incomplete when they scan you, you'll just be rejected (not failed) and told to come back later (they will assume you just had the car serviced or battery disconnected, just agree with them and leave). You can then have your tuner fix the issue and return later for a retest.