No, it's not just for admin. Admittedly, it is the most useful aspect of data assist, but you could also use it for front end where users can enter data into a database, say something like a contact form, or a forum type site. Anywhere you need a form to be honest.
What ever you use it for, it is a useful tool though. It's very rare I have any trouble with it, and the pages it creates in minutes take me hours in dreamweaver.