Art brushes..... no. Art brushes (like pattern brushes) use the base path as a spine to just lie the art along.
Art brushes don't have any rotation dynamics at all, so there's nothing for the tablet to interact with. The brush must have rotation possibilities for any of the tablet features to alter them.
As far as I'm aware, only Scatter, Bristle, and Calligraphic brushes have rotation options. And the Blob Brush Tool (which is really just a calligraphic brush).
FYI.. I use the Wacom Art Pen Stylus, just because I like how it feels in the hand a bit more than the standard Grip Pen Stylus. Having the added dynamics for rotation, angle, etc. can help a great deal in Photoshop, but in Illustrator there's not a great deal of places to use all the possible dynamics the Art Pen Stylus will read. I got the Art Pen Stylus because, like you, I had to replace the stylus.. so $70 for the Grip pen or $90 for the Art Pen... I figured the $20 extra was worth a try and ended up preferring it.