I recently purchased the auto reverse set and I see there is no rolling stock. Is there any particular type that I need for this system?
Any model of the appropriate gauge that's compatible with DC should work just fine.
I was thinking more about the street cars and trollies i.e. Brill Trolley and Peter Witt streetcars, etc. are these the correct compatibility?
Short answer: I don't see why not.
Long answer: The product pages indicate that the Brills are not DCC and the Peter Witts have dual-mode DCC decoders, so both should work on the reversing track which uses standard DC and not DCC.