Athalone is a great place to stop if you're driving between Shannon and Dublin, like many tourists will likely do.

Other than that, I don't think I'd make Athalone a "must stop" on a vacation or a week or two. Fun for a day or so, but after that there isn't much keeping one there.