I have something fairly close to my dream job. I am a copy editor (sub-editor to the Brits, Aussies, Kiwis et al. here)! Have been for 10 years. I say close but not exactly (nothing's perfect) because socially it's disappointing (being invisible and the cliquishness around me) but I know from experience it could be a lot worse.
An ideal job for me is a safe place, related to my skills and interests and social without being threatening, a niche job where I'm doted upon/protected.
Had something similar at a seminary library for a year and a half but it didn't pay enough. I was safe in my corner with lots of books about my interests and it was fairly social at the same time. (Even got my first real - and best - girlfriend there.) Tried to be more normal and switched to another library but that completely backfired - they fired me in three months. The differences were the job had nothing to do with my interest (I was trying to be normal after all), I had nothing in common with the people in that office and I had zero privacy - disaster. The bosses were evil - basically they harassed me out of there because they were reacting badly to the AS. Chain reaction: I reacted badly, the bosses reacted to my reaction, etc.
So beware - be aware. Even safe-looking choices like libraries aren't necessarily safe.
I can do and have done more than I'm doing now - driving around interviewing people and writing feature articles about them.
A dream version of that would be to shadow some celebrity like that to ghostwrite his autobiography. Sampling the good life and getting paid for it!