I've been on the pump for nearly 3 years now. I refused to entertain the idea for a long time as I believed that there'd be a lot I couldn't do (watersports) & clothes that I couldn't wear. I wouldn't give it back now though.
It's been by no means plain sailing & still isn't, but my control is better. Some people seem to have it quite easy, others, like me, still struggle. My hba1c has dropped to 6.9/7 last 2 tests, but it hasn't stopped me spiking after meals and having dozens of hypos every month. Certain people think that this is because I don't try hard enough, but they're wrong.
Anyway, off my soapbox & answer you question. It has been a positive thing for me overall. I now like that I can eat snacks occasionally & just press a button to get more insulin. It has dealt with my very strong dawn phenomenon. It is easy to have a correction bolus if you test & find that you're high. It is easier to deal with the after effects of exercise.
I still waterski & windsurf, but have to be a bit pragmatic control-wise when I'm doing that sort of thing. Hiking is much easier to deal with, just turn down the basal rate an hour before setting off.
I can still wear most clothes, except very clingy dresses. However, I'm getting older & less likely to wear such things anyway.
You do have to accept that it'll be visible most of the time. You can hide it in a bra or thigh pouch, some people put them in their bras (never been comfortable for me), mine goes inside my boot in winter. However, if it's well hidden, you need one with a remote control, or you'll be forever popping off to the loo to get at it to bolus.
Do your research on the different pumps available. Don't let your HCPs tell you that you can only have one type. If you meet the criteria, you are entitled to choose the most appropriate one for you, as long as it's NICE approved.
Things to consider:
Do I want/need a remote control?
How small is the minimum basal increment? (important if you have low insulin requirements)
How many basal rates per day can I programme? (most people use only 8-10, others, like me 16+, it really depends on your unique requirements)
How many basal patterns are available? (I use different patterns for post-exercise, pre-menstrual, weekday/weekends & holidays)
Do I want the option of continuous glucose monitoring? (though very difficult to get NHS funding for this & very expensive)
Do I want to have a tubeless pump? (there is one such pump available, the Omnipod)
You'll probably find that no pump does everything that you want it to, so you'll need to decide the Musts & Wants to decide the best one for you.
I hope that this all helps.