I got the opportunity to go to the Trinity site a number of years ago when we lived in New Mexico. There is really not much to the site (as you might expect), but it was really cool to know you were standing where a nuclear device was detonated.
I believe they still open the site to the public on certain weeks in April and October.