The 5D Mark II if fully capable as a wedding, portrait, macro, landscape, architecture camera. It's not as "low light capable" as newer cameras, but was among the very best in it's day. I have used mine to ISO 1600 (1/125, EF 24-70/2.8 @ 32mm f/5.6):


And even ISO 6400 (1/25, EF 24-70/2.8 @ 70mm f/2.8):


Again at ISO 6400 (1/200, EF 135/2 @ f/2):


It is NOT an ideal camera for sports or other action photography... although you might "get lucky" with it occasionally! The primary shortcoming of the 5DII for any sort of action photography is it's AF system, which was not improved in any way from the original 5D's. Both use an AF system similar to what was intro'd with the 20D in 2004... a very simple 9-point array with only the center one the better "dual axis/cross type". Actually, the 5D/5DII AF got a pseudo "enhancement" with 6 hidden "focus assist" points, clustered right around the center one... but they only work in AI Servo.

So long as you are shooting portraits, landscapes, weddings, architecture, etc... no problem. One Shot works well. Just don't depend on the camera for any sort of action shots. Even with the "assist points", AI Servo in the 5DII just isn't up to tracking fast moving subjects.... though sometimes "ya get lucky" (ISO 800, 1/8000, EF 300/4 @ f/5.6):


Or, sometimes the critters are very cooperative (ISO 1600, 1/250, EF 300/4 + EF 1.4X @ f/8):


It's difficult to show at Internet sizes and resolutions, but with good lenses and reasonably good technique, the 5DII's 21MP would make 16x24" or even a little larger prints pretty easily.

5DII @ ISO 200, 1/60, EF 20mm f/2.8 @ f/11:


5DII @ ISO 6400, 1/30, EF 20mm f/2.8 @ f/11:


If you are looking for an affordable lens to use on the full frame camera, pick up a Canon EF 28-135mm IS USM. So long as its f/3.5-5.6 aperture isn't a problem, it's a surtprisingly capable lens.... rivals the Canon 24-105L and 24-70L for image quality, focus speed, image stabilization.... just not as well built, and a whole lot cheaper (typically under $200 used).

EF 28-135mm IS USM @ 117mm and f/7.1 (on 7D, ISO 400, 1/800):


EF 28-135mm IS USM @ 100mm and f/7.1 (on 7D, ISO 400, 1/800):

Yep, it's perfectly fine. Still running my 40D! The best 12mpxl ever. Have an 5DMIV 30.4mpxl FF and all EF-L lenses. I still think crop sensor is better. Truth be told, I have the cheaper L lenses. They are great on the 40D tack sharp. Not so much on the 5DMIV, and yes I micro focused all. It's technique and right place right time. my equipment

Canon 40D/5DMIV EFS/EF Mount
Canon EF 70-200mm 2.8L Gen 1 no stabilize (the 2nd gen was stolen) with 2.0 II tele convert
Cannon 100mm L macro with ring light
Canon 24-70F4L
Tamron 150-600 gen 2 (it's ok but)-----------

All of the above doesn't equal one good 300mm 2.8L prime with an X2 III tele. Those together are roughly 6K
I cant get there money wise. but learning the equipment I do have has taught me a lot...
Maybe one day.....