Outside of PVP, i have not heard too much on the precise details on what keeps people intrigued in the PVE aspect, i.e Questing and Exploration outside of cyrodil. Some people have said they enjoy all of it simply by soaking it all in and taking it slow, others enjoy the environment.
For those who played the beta, was there any part of the pve in particular that got you excited? Any acute part that really caught your attention and kept you entertained? Part of my reasons for collecting this info is becouse my faction involved many quests that had me searching through crates and picking up bottles, and i only had a couple quests personally that i enjoyed. The first was the mad deadra quest-line (dominion) and the questline that involved saving the queen from danger (the veil?)
Other than those two quests and a bit (a tiny bit) of exploration and roleplaying i found very little content that really excited me