I'm from Philadelphia and was visiting friends in Raleigh over the weekend.  Went to Aries on a whim.  We got there around 9:30 I guess, and it was medium bustling.  CD Music was a good mix.  Crowd very mixed.  Some hipsters, some goths, a few lesbians, a couple of gay guys, one tranny. decent pool table.  Around 10:30 , the DJ started pumping and it was pretty loud.  The dancing is off to a side room, which is where it's the loudest. It would be better if there were a bit less sound in the bar/lounge area and keep it up for the dance floor.  
The bartenders, manager were very friendly and hospitable. 
This place is not for you if you are the conservative Raleigh type.  But if you don't mind a little spice in your gumbo, it can be a fun night out.
                        
more