Remi:
I am a full timer for the last 2 1/2 years and have had my traditional career for 24 years now. I have lived in two major city areas in the RV - DC Metro and now Salt Lake City. It has worked out just fine for me - not sure what "horror stories" you have heard.
If you read my first thread, you'll get the backstory of how I ended up choosing an RV to live in. If I could recommend, whatever you buy - pay it in cash. You'll already be paying ground rent at the RV Park and electricity is usually metered if you are a full timer. Also, once you decide on a park, check if they have age restrictions on rigs that are allowed to be there. Many of them do (10-15 years old) mainly for aethetics - they don't want their place to look like junk yard. Being as this would be your first full timing experience and it seems you have resources and a steady job, I think an RV Park is a great way to get your feet wet and learn about it while still having most of the creature comforts you were used to in a sticks and bricks dwelling (Electric, Sewer, Running water, cable hookup, etc.) There is a lot to learn and the plus is you are still in civilization if something goes wrong rather than on the side of the road.
Down the road you may get wanderlust and decide to travel full time. By then, you will have learned about your RV, and then a whole new set of learning begins (this is the stage I'm getting into now). Things like, how do I get off grid power? How much can I run off that power source? Can I run a fridge/heater/air conditioner? Where do I camp? Get fresh water? Empty my tanks? Etc.
I just recently got a new job that allows me to work from home, so technically I could start being a Nomad BUT a few things that are holding me back just now:
1) I bought the Fifth Wheeler I always wanted, BUT didn't buy a truck to pull it yet. (I wasn't in a rush to go anywhere just yet). That's a sizable investment I would have to make.
2) I would have to make a 2nd sizable investment in solar and/or generator power and until I can really understand my needs and feel comfortable that I know how to properly run and maintain these systems, I'm not ready for it.
Yes, there are cheaper ways to do both of these, HOWEVER, (and this is probably blasphemy to say on this site) I am willing to spend more and spend once for the peace of mind that something isn't going to go haywire or leave me standed somewhere. Also, being that I have no skills in any mechanical trades to help me, I accept that and I am willing to pay more to have it done by a professional and make it dummy proof for me to operate.
Lastly, this will help you figure out what you really want to do. Most folks on here want to be far, far away from civilization and traditional 9-5 careers that I agree are soul sucking. I'm finding I'm a bit different. I think my sweet spot is bigger towns or small cities that have amenities/activites, and ideally, I would proably only do the snowbird thing, rather than boondock on BLM lands and have to move every two weeks. That's not to say I won't do it, but more likely as a special trip to meet up with others, or go to an RTR, rather than that be my daily mode of living.
Good luck, and send me a message if you have any more questions!