Just out of pure curiosity, does anyone know of any case where it hasn't been successful and the couple realise too late that they're not right for each other?
I'm sure it must happen at least some of the time, although it's probably unusual.
It happens enough to keep at least me busy. It's called "Curtailment", and it is generally a personal disaster for the immigrant spouse - who may not even be at fault. In fact I haven't seen a recent case where the immigrant spouse could be blamed for anything - ...except for picking an absolute twit for a husband.
I have one coming up where the wife and her child by a former have to be gone by the 23rd of July, and there's absolutely NOTHING at all that can be done about it. The Brit husband decided he liked someone else better and reported it to the Home Office before anything could be done from the advocacy side. I thought it is distasteful that the Moscow consulate is processing his 2nd application there when his 1st wife is still in the country, and I plan on writing a caustic complaint about it. And it's heart-breaking to see a kid's life jerked around like that anyway.
In the last one, the spouse came in as a fiance, they got married, and then decided to split after 7 months. Then she started living with another guy. And when her visa was due to expire, they were 10 months short for unmarried partners, but I managed to get her switched into a 1 year volunteer visa. It's for a local authority, and she was taken on as a (heaven help us) HR Strategist

So that's a happy ending, and they are madly in love with each other anyway - I expect they will get married after she gets her UP. Another time I got one switched into a journalist, and she makes ends meet by doubling as a house-minder, and the last time I talked to her she was booked up until next year and happy as a clam.
The rule of thumb in curtailment is: if you think it's going to happen, get to an advisor FAST! It's something you can't do alone.