I had ZERO experience doing any kind of club dancing until after college, and then experienced "grinding" mainly as "creepy guy comes up behind me and rubs his erection into my ass without any prior eye contact" in skeevy clubs, so no, it's not particularly attractive.