Can it detect problems in basic schematics consisting of say 5-10 transistors, and perhaps a bunch of resistors and capacitors?

Would it be able to detect issues with functionality, and maximum ratings?

Yes. I’d recommend trying the free plan with your design to see how it performs. You can also steer the review in a specific direction using custom instructions in "Advanced Options" if there are particular parts of the design you want analyzed.