You want the truth? You can't handle the truth!
Sorry, just had to get that out of the way...
Firstly, We have never met anyone that has tried caravanning and not liked it.
Which is not to say it's a racing cert that you will, but the chances are good, depending on what you want from a holiday. You can't rely on British weather, for that you need to go abroad, but you can still take your van with you.
As for finance, it can be as cheap or extravagant as you want to make it. Go for the latest equipment and caravan and yes, it is expensive. Go for a cheap and cheerful van, park it at home and service what you can yourself and it is exceptional value for money. Even the expensive route can be cost effective if you use your van often.
Your asking the converted, on this forum, we wouldn't be here if we didn't like getting away, so your going to get a positive response to your question, what you have to ask yourself is, what do I want from the holiday? If it's relaxation, the chance to just pick up sticks and move at a whim or having your very own hotel room on wheels then give it a go. I would recommend you start with a good second-hand van first; you wont loose much when it comes to sell and it will give you the opportunity to change for your ideal van when you know exactly what you want.
Whatever you do, welcome to the club, and that reminds me, join one of those too!