I think each DLC has a pretty clear introduction, with a 'are you sure you want to start, you won't be able to go back to the Mojave until the end' on the door/object that triggers the start, and usually mentions the actual DLC name.
As for quest titles:
Sierra Madre Grand Opening! - Dead Money
Happy Trails Expedition - Honest Hearts
Midnight Science Fiction Feature! - Old World Blues
The Reunion - Lonesome Road