Rohn 25 is very strong if installed according to Rohn specs. I have felt very secure at over 100 feet working on these towers. If your tower is not guyed a considerable base is required. A guyed tower may require less concrete, check ROHN data. You could possibly use orthagonal 40 and 80 meter dipoles as top guy wires on a 30 or 40 foot tower, with possibly less strengent base requirements. Check the ROHN data. There are some good arguments for locating a tower away from your house or shack, however look into the possibility of putting the tower a few feet from a structure and bracketing it to the structure. However, engineer the attachment to the structure, do not just lag it into the siding. ROHN has specs, I believe on how high you can go with a solid attachment point instead of guy wires. On my towers, I buried part of a section in the concrete base, then after a few days, just stacked additional sections to go to 40 and 60 feet on my guyed towers. If you feel safe climbing and have perhaps 2 helpers it is easy to stack sections with a gin pole, or if you are young and strong even without the pole, however this is NOT recommended since things can go wrong without the gin pole.
I have designed installations with antennas on top of modest height towers, like 40 feet. It is true that the horizontal force tending to push a tower over from a modest antenna is small, however the torque at the bottom of a self supporting tower quickly becomes very significant, probably at least a few thousand foot pounds. Even a trap vertical on the top of a 30 or 40 foot self supporting tower will result in significant torque at the bottom of a self supporting tower.
Personally I like the idea of a good solid say 30 or 40 foot ROHN tower. I still climb at 81 years old, and can hang various dipoles, from the top or even stack additional sections to extend the height many more. Climbing is potentially very dangereous, requires hundreds of dollars of equipment and a few qualified helpers. Working on antenna crews, we needed to be re-certified every few years, which was at least a few day course where we practiced rescue techniques. Remember if you call 911, your local fire department may not be able to rescue you if you become incapacited on top of your tower.
Download and study the ROHN tower installation guide. Also I believe ARRL has books on tower installation and safety.
Rick KL7CW