First: please remember that depth is all relative to a new diver
My wife and I have each been active snorkelers for our entire lives. While on vacation in Aruba this past summer, I decided to take the next step and I took a resort course. The dive was simple and we basically sat down at 30 feet for about 20 minutes and then went back up. I thoroughly enjoyed the experience and I want both of us to get certified before our next tropical vacation.
What my wife and I really want to get out of this is simply the ability to do very shallow dives (15'-30') that will allow us to see more of the reef than we would at the surface. Neither of us has much interest in diving to deeper wrecks, wall dives, etc. As I read more about PADI certification, it appears that the instructor can take you down to 60 feet and have you perform all the skills at that depth. I'm a little nervous about doing skills at that depth (hey, it's all relative), as I'm afraid that I'll panic and do something stupid. I was perfectly calm during my resort course, but I had stayed within reasonable distance of the surface, which provided a (possibly silly) peace of mind. I'm very aware that some of the biggest risks are from 0-30' depth, but I'm more concerned that I will panic when I get too far from the surface.
Do you think scuba is for me?
First, welcome to SB. I'm sure that you will find many opinions that will be contradictory from time to time, but after you wade through them, you will likely have enough information to make-up your mind on most issues.
The "deep water" check-out makes many people nervous. If you remember that there's nothing that can happen here than at 30', it puts things into perspective. Your buddy and Instructor are right there and you should be up to the experience or the Instructor shouldn't put you in the situation to begin with. You may be a bit jittery, but that can be expected.
After you're certified, you can dive how you like. You can still keep it shallow, as many divers do. Over time you will develop a higher degree of comfort and will eventually be an old hand.
Good luck with your adventure!
Wayne