Bermuda is amazing. I stayed at Elbow Beach.
As for how much spending money to bring? That depends on you & what you plan to do.
The US Dollar is accepted everywhere there.
If you get the chance rent a moped & tour the Island. Only 25 miles long & great beaches. Watch out for the coral along the sides of the road very SHARP!
Enjoy.