Yes, there are many interesting and useful plug-ins that make an old 7000 Tek scope worthwhile. The 7904 is especially attractive because it has no fan and so it runs nice and quiet. The mainframes are expensive to ship, so if you can find one in good shape locally you have won more than half the battle. Plug-ins are plentiful on eBay and inexpensive to ship. If you are patient, you can put together an amazing capability for little outlay.
I think it is as JuiceKing says.
The 7904 will take up a fair amount of space and it's heavy, so finding one locally or one that has affordable shipping that will arrive safely in good condition and then finding a place to put it is roughly half the battle. After that there are lots of fun possibilities. The caveat is that we're talking half a hundred years old so it's hard to predict exactly how well and how long everything runs but back in the day Tektronix built some seriously great gear so with a bit of luck a lot is possible.
Overall, I'd say you are headed on a good path but before you officially adopt the 7904 route you might take a look at Howardlong's posts on the HP 54121T; it looks to offer some very good performance in somewhat more modern packaging. I'm not sure about the price differences and I'm not saying the 54121T is as good or better overall than the Tek mainframe approach but it's probably worth a look.
In my experience you have to plan for about a 2:1 ratio on Tek 7000 plug-ins; for every 2 you wind up with, 1 might work just the way you want. The good news is that if you are handy with repairs you will acquire some spare parts - whether those are the parts you will need later is harder to say.
Among the plug-ins I'd recommend would be the 7A29 (or 7A29P), 7S12 (with a S-4 or S-6 and a S-52), and a 7B92A. The 7A26 and 7D15 are worth a look too, and I'm sure there are plenty of others to keep you occupied. eBay can be a good source but you have to study the pictures and writes-up carefully along with the seller's MO, and then still be ready for the 2:1 factor.
If you search in the forums here you can find a fair amount of discussion on the 7904 and other Tek 7000 series products. Plenty of people here will tell you to save your money, time, and space for more modern gear but there are enough other Tek vintage fans around that you won't be completely lonely with a Tek vintage addiction in case you acquire it.
EEVblog legend/philosophy is that until you have something like 19 scopes you haven't hit your quota, so using one allocation out of 19 for a 7904 doesn't seem too unreasonable.
Here's one of a bunch of threads you might find interesting:
https://www.eevblog.com/forum/testgear/40-ps-rise-time/