When they say a show is at eight, is that the main event, the opening act, or doors? What time should I expect doors to open?

I think it depends on the act but just show up an hour early and have a drink in the bar.

Isn't the opening act part of the show you paid for?

Depends of they have a support act. If the doors open a different time, they usually specify. Call the venue to double check!