The long topic says it all. I've watched a few play through videos and read the rule book but can't figure out if the investigator stays in the room where they failed the tasks, or if they go back to the entrance of the museum. Any and all help is greatly appreciated and thanks in advance.

If you fail resolving an adventure, you're forced to stay on the adventure you fail. You can leave during your next Movement Phase, the following turn.

Thanks so much!

Just to add. ..If you note the rooms that have a cost to enter, the rules mention you only pay it upon entering and if you stay for subsequent turns you do not have to pay each time as you are already there (unless you leave and re enter of course).